APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_ENTRY_HEADERS

Line 45: FROM GCS_ENTRY_HEADERS

41: IF (p_entry_id IS NOT NULL OR p_run_detail_id IS NOT NULL) THEN
42: IF (p_entry_id IS NOT NULL) THEN
43: SELECT entry_id, entity_id, currency_code
44: BULK COLLECT INTO l_entry_id_list, l_entity_id_list, l_currency_code_list
45: FROM GCS_ENTRY_HEADERS
46: WHERE entry_id = p_entry_id;
47:
48: ELSE -- p_run_detail_id is not null
49: SELECT ghd.entry_id, ghd.entity_id, ghd.currency_code

Line 52: GCS_ENTRY_HEADERS GHD

48: ELSE -- p_run_detail_id is not null
49: SELECT ghd.entry_id, ghd.entity_id, ghd.currency_code
50: BULK COLLECT INTO l_entry_id_list, l_entity_id_list, l_currency_code_list
51: FROM GCS_CONS_ENG_RUN_DTLS GCR,
52: GCS_ENTRY_HEADERS GHD
53: WHERE GCR.run_detail_id = p_run_detail_id
54: AND GHD.entry_id in ( GCR.entry_id, GCR.stat_entry_id);
55: END IF;
56:

Line 105: GCS_ENTRY_HEADERS GHD

101: FROM dual
102: WHERE EXISTS
103: (SELECT 1
104: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
105: GCS_ENTRY_HEADERS GHD
106: WHERE GCERD.run_name = p_run_name
107: AND GCERD.consolidation_entity_id = p_cons_entity_id
108: AND GCERD.child_entity_id = p_child_entity_id
109: AND GCERD.category_code = p_category_code

Line 159: GCS_ENTRY_HEADERS GHD,

155: sum(nvl(GLE.PTD_CREDIT_BALANCE_E, GLE.YTD_CREDIT_BALANCE_E)) PTD_CREDIT_BALANCE_E,
156: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
157: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
158: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
159: GCS_ENTRY_HEADERS GHD,
160: GCS_ENTRY_LINES GLE
161: WHERE GCERD.run_name = p_run_name
162: AND GCERD.consolidation_entity_id = p_cons_entity_id
163: AND GCERD.child_entity_id = p_child_entity_id

Line 223: GCS_ENTRY_HEADERS GHD,

219: sum(nvl(GLE.PTD_CREDIT_BALANCE_E, GLE.YTD_CREDIT_BALANCE_E)) PTD_CREDIT_BALANCE_E,
220: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
221: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
222: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
223: GCS_ENTRY_HEADERS GHD,
224: GCS_ENTRY_LINES GLE
225: WHERE GCERD.run_name = p_run_name
226: AND GCERD.consolidation_entity_id = p_cons_entity_id
227: AND GCERD.child_entity_id = p_child_entity_id

Line 245: GCS_ENTRY_HEADERS GHD

241: FROM dual
242: WHERE EXISTS
243: (SELECT 1
244: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
245: GCS_ENTRY_HEADERS GHD
246: WHERE GCERD.run_name = p_run_name
247: AND GCERD.consolidation_entity_id = p_cons_entity_id
248: AND GCERD.category_code = p_category_code
249: AND GHD.entry_id in (GCERD.entry_id, GCERD.stat_entry_id)

Line 298: GCS_ENTRY_HEADERS GHD,

294: sum(nvl(GLE.PTD_CREDIT_BALANCE_E, GLE.YTD_CREDIT_BALANCE_E)) PTD_CREDIT_BALANCE_E,
295: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
296: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
297: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
298: GCS_ENTRY_HEADERS GHD,
299: GCS_ENTRY_LINES GLE
300: WHERE GCERD.run_name = p_run_name
301: AND GCERD.consolidation_entity_id = p_cons_entity_id
302: AND GCERD.category_code = p_category_code

Line 361: GCS_ENTRY_HEADERS GHD,

357: sum(nvl(GLE.PTD_CREDIT_BALANCE_E, GLE.YTD_CREDIT_BALANCE_E)) PTD_CREDIT_BALANCE_E,
358: sum(GLE.YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E,
359: sum(GLE.YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E
360: FROM GCS_CONS_ENG_RUN_DTLS GCERD,
361: GCS_ENTRY_HEADERS GHD,
362: GCS_ENTRY_LINES GLE
363: WHERE GCERD.run_name = p_run_name
364: AND GCERD.consolidation_entity_id = p_cons_entity_id
365: AND GCERD.category_code = p_category_code

Line 876: FROM gcs_entry_headers

872: --This mode will only be called for removal of Translation Rows
873: ELSIF p_undo = 'Y' AND p_entry_id IS NOT NULL THEN
874: SELECT entity_id
875: INTO l_entity_id
876: FROM gcs_entry_headers
877: WHERE entry_id = p_entry_id;
878:
879: DELETE /*+ INDEX(FEM_BALANCES FEM_BALANCES_N4) */ FROM FEM_BALANCES
880: WHERE dataset_code = p_hier_dataset_code