JL Mexican Chart of Accounts - XML File

 SELECT  SUBSTR(reg.registration_number,1,13) rfc_number,
                            to_char(sysdate,'MM') month,
                            to_char(sysdate,'RRRR') year
                      FROM  xle_registrations reg,
                            xle_jurisdictions_vl jur
                     WHERE  reg.source_id       =  (Select legal_entity_id
                                                    From jl_mx_gl_configs 
                                                    Where config_id = :p_config_id)
                       AND  reg.source_table    = 'XLE_ENTITY_PROFILES'
                       AND  reg.jurisdiction_id = jur.jurisdiction_id
                       AND  jur.registration_code_le   = 'RFC'
                       AND  sysdate between nvl(reg.effective_from,sysdate) and Nvl(reg.effective_to,sysdate)
                       AND  rownum=1