APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 51: FROM GCS_CONS_ENG_RUN_DTLS GCR,

47:
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;

Line 104: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

100: INTO l_recur_entry_flag
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

Line 158: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

154: sum(nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E)) PTD_DEBIT_BALANCE_E,
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

Line 222: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

218: sum(nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E)) PTD_DEBIT_BALANCE_E,
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

Line 244: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

240: INTO l_recur_entry_flag
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

Line 297: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

293: sum(nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E)) PTD_DEBIT_BALANCE_E,
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

Line 360: FROM GCS_CONS_ENG_RUN_DTLS GCERD,

356: sum(nvl(GLE.PTD_DEBIT_BALANCE_E, GLE.YTD_DEBIT_BALANCE_E)) PTD_DEBIT_BALANCE_E,
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

Line 857: FROM gcs_cons_eng_run_dtls

853: -- Bugfix 5704055: This mode will only be called when removing Data Prep and Aggregation Rows
854: IF p_undo = 'Y' AND p_entry_id IS NULL THEN
855: SELECT child_entity_id
856: INTO l_entity_id
857: FROM gcs_cons_eng_run_dtls
858: WHERE run_detail_id = p_run_detail_id;
859:
860: DELETE /*+ INDEX(FEM_BALANCES FEM_BALANCES_N4) */ FROM FEM_BALANCES
861: WHERE dataset_code = p_hier_dataset_code