DBA Data[Home] [Help]

APPS.GCS_PERIOD_INIT_DYNAMIC_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 96: FROM gcs_cons_eng_run_dtls gcerd,

92: 'N',
93: 0
94: BULK COLLECT INTO
95: l_entry_id_list
96: FROM gcs_cons_eng_run_dtls gcerd,
97: gcs_entry_headers geh
98: WHERE gcerd.run_name = p_run_name
99: AND gcerd.consolidation_entity_id = p_cons_entity_id
100: AND gcerd.child_entity_id IS NOT NULL

Line 113: FROM gcs_cons_eng_run_dtls gcerd,

109: 'N',
110: 0
111: BULK COLLECT INTO
112: l_entry_id_list
113: FROM gcs_cons_eng_run_dtls gcerd,
114: gcs_entry_headers geh
115: WHERE gcerd.run_name = p_run_name
116: AND gcerd.consolidation_entity_id = p_cons_entity_id
117: AND gcerd.child_entity_id IS NOT NULL

Line 129: FROM gcs_cons_eng_run_dtls gcerd,

125: geh.period_init_entry_flag,
126: NVL(geh.end_cal_period_id, geh.start_cal_period_id) - geh.start_cal_period_id
127: BULK COLLECT INTO
128: l_entry_id_list
129: FROM gcs_cons_eng_run_dtls gcerd,
130: gcs_entry_headers geh
131: WHERE gcerd.run_name = p_run_name
132: AND gcerd.consolidation_entity_id = p_cons_entity_id
133: AND gcerd.child_entity_id IS NOT NULL

Line 148: FROM gcs_cons_eng_run_dtls gcerd,

144: 'N',
145: 0
146: BULK COLLECT INTO
147: l_entry_id_list
148: FROM gcs_cons_eng_run_dtls gcerd,
149: gcs_entry_headers geh
150: WHERE gcerd.run_name = p_run_name
151: AND gcerd.consolidation_entity_id = p_cons_entity_id
152: AND gcerd.child_entity_id = p_entity_id

Line 165: FROM gcs_cons_eng_run_dtls gcerd,

161: 'N',
162: 0
163: BULK COLLECT INTO
164: l_entry_id_list
165: FROM gcs_cons_eng_run_dtls gcerd,
166: gcs_entry_headers geh
167: WHERE gcerd.run_name = p_run_name
168: AND gcerd.consolidation_entity_id = p_cons_entity_id
169: AND gcerd.child_entity_id = p_entity_id

Line 181: FROM gcs_cons_eng_run_dtls gcerd,

177: geh.period_init_entry_flag,
178: NVL(geh.end_cal_period_id, geh.start_cal_period_id) - geh.start_cal_period_id
179: BULK COLLECT INTO
180: l_entry_id_list
181: FROM gcs_cons_eng_run_dtls gcerd,
182: gcs_entry_headers geh
183: WHERE gcerd.run_name = p_run_name
184: AND gcerd.consolidation_entity_id = p_cons_entity_id
185: AND gcerd.child_entity_id = p_entity_id