DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_ENTITIES_B

Line 102: fem_entities_b feb,

98: p_datasub_info.source_system_code,
99: p_datasub_info.dataset_code,
100: p_datasub_info.ds_balance_type_code
101: FROM gcs_data_sub_dtls gdsd,
102: fem_entities_b feb,
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,
106: fem_datasets_attr fda,

Line 2550: fem_entities_b feb,

2546:
2547: SELECT gea.entity_id BULK COLLECT
2548: INTO l_entity_list
2549: FROM gcs_entities_attr gea,
2550: fem_entities_b feb,
2551: fem_cal_periods_attr fcpa
2552: WHERE gea.balances_rule_id = l_bal_rule_id
2553: AND gea.source_system_code = 10
2554: AND gea.data_type_code = 'ACTUAL'

Line 2838: fem_entities_b feb,

2834: fem_cctr_orgs_hier fcoh,
2835: fem_cctr_orgs_attr fcoa,
2836: gcs_entity_cctr_orgs geco,
2837: gcs_entities_attr gea,
2838: fem_entities_b feb,
2839: fem_cal_periods_attr fcpa
2840: WHERE feb.entity_id = gea.entity_id
2841: AND geco.entity_id = gea.entity_id
2842: AND geco.company_cost_center_org_id = fcoa.company_cost_center_org_id

Line 2876: fem_entities_b feb

2872: INTO l_entity_list
2873: FROM fem_companies_b fcb,
2874: gcs_entity_organizations geo,
2875: gcs_entities_attr gea,
2876: fem_entities_b feb
2877: WHERE feb.entity_id = gea.entity_id
2878: AND geo.entity_id = gea.entity_id
2879: AND feb.enabled_flag = 'Y'
2880: AND gea.balances_rule_id = l_bal_rule_id