APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_ENTITY_CCTR_ORGS

Line 423: gcs_entity_cctr_orgs geco,

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;
426: l_where_text :=
427: '

Line 462: gcs_entity_cctr_orgs geco '|| l_from_text;

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
466: AND fb.source_system_code = :source_system_code

Line 750: gcs_entity_cctr_orgs geco

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
754: AND fb.currency_type_code = p_currency_type_code

Line 786: gcs_entity_cctr_orgs geco

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
790: AND fb.currency_type_code = p_currency_type_code

Line 824: gcs_entity_cctr_orgs geco

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
828: AND fb.currency_type_code = p_currency_type_code

Line 861: gcs_entity_cctr_orgs geco

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
865: AND fb.currency_type_code = p_currency_type_code

Line 1623: gcs_entity_cctr_orgs geco,

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
1626: WHERE fb.ledger_id = p_source_ledger_id
1627: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER

Line 1671: gcs_entity_cctr_orgs geco,

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
1674: WHERE fb.ledger_id = p_source_ledger_id
1675: AND fb.source_system_code = fla.DIM_ATTRIBUTE_NUMERIC_MEMBER