APPS.GMS_RES_MAP dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 2015: pa_resource_list_assignments prla

2011:
2012: select prm.resource_list_member_id
2013: into x_resource_list_member_id
2014: from pa_resource_maps prm,
2015: pa_resource_list_assignments prla
2016: where prla.resource_list_assignment_id = prm.resource_list_assignment_id
2017: and prla.project_id = x_project_id
2018: and prm.resource_list_id = x_res_list_id
2019: and prm.organization_id = x_organization_id

Line 2204: pa_resource_list_assignments

2200: prm.resource_list_assignment_id IN
2201: ( SELECT
2202: resource_list_assignment_id
2203: FROM
2204: pa_resource_list_assignments
2205: WHERE project_id = x_project_id
2206: AND resource_list_id = NVL(x_resource_list_id,resource_list_id)
2207: );
2208:

Line 2320: pa_resource_list_assignments

2316:
2317: -- pa_debug.debug(x_err_stage);
2318:
2319: UPDATE
2320: pa_resource_list_assignments
2321: SET
2322: resource_list_changed_flag ='N'
2323: WHERE
2324: resource_list_assignment_id = x_resource_list_assignment_id;

Line 2346: pa_resource_list_assignments

2342: NVL(resource_list_changed_flag,'N')
2343: INTO
2344: x_resource_list_changed_flag
2345: FROM
2346: pa_resource_list_assignments
2347: WHERE
2348: resource_list_assignment_id = x_resource_list_assignment_id;
2349:
2350: RETURN x_resource_list_changed_flag;

Line 2618: pa_resource_list_assignments rla

2614: pa_resource_list_members rlm,
2615: pa_resource_txn_attributes rta,
2616: pa_resources r,
2617: pa_resource_types rt,
2618: pa_resource_list_assignments rla
2619: WHERE
2620: rlm.resource_list_id = rl.resource_list_id
2621: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)
2622: AND NVL(rlm.parent_member_id,0) = 0

Line 2671: pa_resource_list_assignments rla

2667: pa_resource_txn_attributes rtac,
2668: pa_resource_txn_attributes rtap,
2669: pa_resources rc,
2670: pa_resource_types rtc,
2671: pa_resource_list_assignments rla
2672: WHERE
2673: rlmc.resource_list_id = rl.resource_list_id
2674: AND rl.resource_list_id = NVL(x_res_list_id,rl.resource_list_id)
2675: --AND rlmc.enabled_flag = 'Y' --Bug Fix 1370475