APPS.PA_RES_ACCUMS dependencies on PA_RESOURCE_MAPS

Line 71: pa_resource_maps prm

67: INTO
68: x_resource_list_member_id,
69: x_resource_id
70: FROM
71: pa_resource_maps prm
72: WHERE
73: prm.resource_list_assignment_id = x_resource_list_assignment_id
74: AND prm.resource_list_id = x_resource_list_id
75: AND prm.expenditure_type = x_expenditure_type

Line 94: pa_resource_maps prm

90: INTO
91: x_resource_list_member_id,
92: x_resource_id
93: FROM
94: pa_resource_maps prm
95: WHERE
96: prm.resource_list_assignment_id = x_resource_list_assignment_id
97: AND prm.resource_list_id = x_resource_list_id
98: AND prm.expenditure_type = x_expenditure_type

Line 118: pa_resource_maps prm

114: INTO
115: x_resource_list_member_id,
116: x_resource_id
117: FROM
118: pa_resource_maps prm
119: WHERE
120: prm.resource_list_assignment_id = x_resource_list_assignment_id
121: AND prm.resource_list_id = x_resource_list_id
122: AND prm.event_type = x_event_type

Line 185: pa_resource_maps prm,

181: INTO
182: x_resource_list_member_id,
183: x_resource_id
184: FROM
185: pa_resource_maps prm,
186: pa_resource_list_assignments parla
187: WHERE
188: prm.resource_list_id = x_resource_list_id
189: AND prm.expenditure_type = x_expenditure_type

Line 211: pa_resource_maps prm,

207: INTO
208: x_resource_list_member_id,
209: x_resource_id
210: FROM
211: pa_resource_maps prm,
212: pa_resource_list_assignments parla
213: WHERE
214: prm.resource_list_id = x_resource_list_id
215: AND prm.expenditure_type = x_expenditure_type

Line 238: pa_resource_maps prm,

234: INTO
235: x_resource_list_member_id,
236: x_resource_id
237: FROM
238: pa_resource_maps prm,
239: pa_resource_list_assignments parla
240: WHERE
241: prm.resource_list_id = x_resource_list_id
242: AND prm.event_type = x_event_type

Line 279: pa_resource_maps where rownum <= pa_proj_accum_main.x_commit_size;

275:
276: Loop
277: IF (x_resource_list_assignment_id is null) THEN
278: DELETE
279: pa_resource_maps where rownum <= pa_proj_accum_main.x_commit_size;
280: ELSE
281: DELETE
282: pa_resource_maps prm
283: WHERE

Line 282: pa_resource_maps prm

278: DELETE
279: pa_resource_maps where rownum <= pa_proj_accum_main.x_commit_size;
280: ELSE
281: DELETE
282: pa_resource_maps prm
283: WHERE
284: prm.resource_list_assignment_id = x_resource_list_assignment_id
285: and rownum <= pa_proj_accum_main.x_commit_size;
286: END IF;

Line 333: pa_resource_maps prm

329:
330: LOOP
331:
332: DELETE
333: pa_resource_maps prm
334: WHERE
335: prm.resource_list_assignment_id IN
336: ( SELECT
337: resource_list_assignment_id

Line 398: INSERT INTO pa_resource_maps

394: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
395: pa_debug.debug('old_map_txns: ' || x_err_stage);
396: END IF;
397:
398: INSERT INTO pa_resource_maps
399: (resource_list_id,
400: resource_list_assignment_id,
401: resource_list_member_id,
402: resource_id,