APPS.PA_RES_ACCUMS dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 186: pa_resource_list_assignments parla

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
190: AND prm.organization_id = x_organization_id

Line 212: pa_resource_list_assignments parla

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
216: AND prm.organization_id = x_organization_id

Line 239: pa_resource_list_assignments parla

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
243: AND prm.organization_id = x_organization_id

Line 339: pa_resource_list_assignments

335: prm.resource_list_assignment_id IN
336: ( SELECT
337: resource_list_assignment_id
338: FROM
339: pa_resource_list_assignments
340: WHERE project_id = x_project_id
341: AND resource_list_id = NVL(x_resource_list_id,resource_list_id)
342: )
343: and rownum <= pa_proj_accum_main.x_commit_size;

Line 472: pa_resource_list_assignments

468: pa_debug.debug('old_map_txns: ' || x_err_stage);
469: END IF;
470:
471: UPDATE
472: pa_resource_list_assignments
473: SET
474: resource_list_changed_flag ='N'
475: WHERE
476: resource_list_assignment_id = x_resource_list_assignment_id;

Line 500: pa_resource_list_assignments

496: NVL(resource_list_changed_flag,'N')
497: INTO
498: x_resource_list_changed_flag
499: FROM
500: pa_resource_list_assignments
501: WHERE
502: resource_list_assignment_id = x_resource_list_assignment_id;
503:
504: RETURN x_resource_list_changed_flag;

Line 808: pa_resource_list_assignments rla

804: pa_resource_list_members rlm,
805: pa_resource_txn_attributes rta,
806: pa_resources r,
807: pa_resource_types rt,
808: pa_resource_list_assignments rla
809: WHERE
810: rlm.resource_list_id = rl.resource_list_id
811: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)
812: and nvl(rl.migration_code,'-99') <> 'N'

Line 861: pa_resource_list_assignments rla

857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,
860: pa_resource_types rtc,
861: pa_resource_list_assignments rla
862: WHERE
863: rlmc.resource_list_id = rl.resource_list_id
864: and nvl(rl.migration_code,'-99') <> 'N'
865: and nvl(rlmc.migration_code,'-99') <> 'N'

Line 1599: FROM pa_resource_list_assignments prla,

1595:
1596: CURSOR C1 IS
1597: SELECT prla.resource_list_id
1598: ,prla.resource_list_assignment_id
1599: FROM pa_resource_list_assignments prla,
1600: pa_resource_lists_all_bg res
1601: WHERE prla.resource_list_id = nvl(x_res_list_id,prla.resource_list_id)
1602: AND prla.project_id = x_project_id
1603: AND res.resource_list_id = prla.resource_list_id