[Home] [Help]
417: SYSDATE,
418: FND_GLOBAL.USER_ID,
419: FND_GLOBAL.LOGIN_ID ';
420: l_from_text := '
421: FROM fem_balances fb,
422: fem_ledgers_attr fla,
423: gcs_entity_cctr_orgs geco,
424: gcs_cons_impact_analyses gcia,
425: gcs_data_sub_dtls gdsd '|| l_from_text;
457: :p_max_period, NVL(fb.ytd_debit_balance_e,0) - NVL (fb.ytd_credit_balance_e,0), 0
458: ) ytd_balance_e
459: ';
460: l_from_text := '
461: FROM fem_balances fb,
462: gcs_entity_cctr_orgs geco '|| l_from_text;
463: l_where_text := '
464: WHERE :source_cal_period_id = fb.cal_period_id
465: AND fb.ledger_id = :p_source_ledger_id
692: WHERE fdl.ledger_id = ' ||p_source_ledger_id||'
693: AND fdl.cal_period_id = cpmgt.source_cal_period_id
694: AND fdl.source_system_code = '||l_source_system_code||'
695: AND fdl.dataset_code = ' ||p_source_dataset_code||'
696: AND fdl.table_name = ''FEM_BALANCES''');
697: END IF;
698:
699: SELECT cpmgt.source_cal_period_id cal_period_id
700: BULK COLLECT INTO l_periods_list
703: WHERE fdl.ledger_id = p_source_ledger_id
704: AND fdl.cal_period_id = cpmgt.source_cal_period_id
705: AND fdl.source_system_code = l_source_system_code
706: AND fdl.dataset_code = p_source_dataset_code
707: AND fdl.table_name = 'FEM_BALANCES';
708:
709: IF l_periods_list.FIRST IS NULL THEN
710: RAISE no_data_error;
711: END IF;
745: DECODE (fb.cal_period_id,
746: p_max_period, NVL(fb.ytd_debit_balance_e,0) - NVL (fb.ytd_credit_balance_e,0), 0
747: ) ytd_balance_e
748:
749: FROM fem_balances fb,
750: gcs_entity_cctr_orgs geco
751: WHERE l_periods_list(counter) = fb.cal_period_id
752: AND fb.source_system_code = l_source_system_code
753: AND fb.ledger_id = p_source_ledger_id
781: DECODE (fb.cal_period_id,
782: p_max_period, NVL(fb.ytd_debit_balance_e,0) - NVL (fb.ytd_credit_balance_e,0), 0
783: ) ytd_balance_e
784:
785: FROM fem_balances fb,
786: gcs_entity_cctr_orgs geco
787: WHERE l_periods_list(counter) = fb.cal_period_id
788: AND fb.source_system_code = l_source_system_code
789: AND fb.ledger_id = p_source_ledger_id
819: DECODE (fb.cal_period_id,
820: p_max_period, NVL(fb.ytd_debit_balance_e,0) - NVL (fb.ytd_credit_balance_e,0), 0
821: ) ytd_balance_e
822:
823: FROM fem_balances fb,
824: gcs_entity_cctr_orgs geco
825: WHERE l_periods_list(counter) = fb.cal_period_id
826: AND fb.source_system_code = l_source_system_code
827: AND fb.ledger_id = p_source_ledger_id
856: DECODE (fb.cal_period_id,
857: p_max_period, NVL(fb.ytd_debit_balance_e,0) - NVL (fb.ytd_credit_balance_e,0), 0
858: ) ytd_balance_e
859:
860: FROM fem_balances fb,
861: gcs_entity_cctr_orgs geco
862: WHERE l_periods_list(counter) = fb.cal_period_id
863: AND fb.source_system_code = l_source_system_code
864: AND fb.ledger_id = p_source_ledger_id
1210: NVL (fb.ytd_credit_balance_e, 0)
1211: + NVL (gel.ptd_credit_balance_e, 0),
1212: NVL (fb.ytd_debit_balance_e, 0)
1213: + NVL (gel.ptd_debit_balance_e, 0)
1214: FROM fem_balances fb,
1215: fem_ln_items_attr flia,
1216: fem_ext_acct_types_attr feata
1217: WHERE feata.dim_attribute_varchar_member IN
1218: (''REVENUE'', ''EXPENSE'')
1235: NVL (fb.ytd_credit_balance_e, 0)
1236: + NVL (gel.ptd_credit_balance_e, 0),
1237: NVL (fb.ytd_debit_balance_e, 0)
1238: + NVL (gel.ptd_debit_balance_e, 0)
1239: FROM fem_balances fb,
1240: fem_ln_items_attr flia,
1241: fem_ext_acct_types_attr feata
1242: WHERE feata.dim_attribute_varchar_member IN ('REVENUE', 'EXPENSE')
1243: AND flia.attribute_id = g_li_eat_attr_id
1617: FND_GLOBAL.USER_ID,
1618: SYSDATE,
1619: FND_GLOBAL.USER_ID,
1620: FND_GLOBAL.LOGIN_ID
1621: FROM fem_balances fb,
1622: fem_ledgers_attr fla,
1623: gcs_entity_cctr_orgs geco,
1624: gcs_cons_impact_analyses gcia,
1625: gcs_data_sub_dtls gdsd
1665: FND_GLOBAL.USER_ID,
1666: SYSDATE,
1667: FND_GLOBAL.USER_ID,
1668: FND_GLOBAL.LOGIN_ID
1669: FROM fem_balances fb,
1670: fem_ledgers_attr fla,
1671: gcs_entity_cctr_orgs geco,
1672: gcs_cons_impact_analyses gcia,
1673: gcs_data_sub_dtls gdsd