1047: ,DECODE(glp.period_num,1,decode(glp2.period_num,1,decode(sign(glp.effective_period_num-xlp.min_effect_period_num),0,NULL,'IB027'),NULL),NULL) IB027
1048: FROM xla_ctrl_balances_int xib
1049: ,xla_subledgers xls
1050: ,gl_ledgers gll
1051: ,gl_ledger_relationships glr
1052: ,gl_code_combinations gcc
1053: ,ap_suppliers aps
1054: ,ap_supplier_sites_all apsa
1055: ,hz_parties hzp