APPS.GMS_RES_MAP dependencies on PA_RESOURCE_MAPS

Line 2014: from pa_resource_maps prm,

2010: Begin
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

Line 2082: pa_resource_maps prm

2078: INTO
2079: x_resource_list_member_id,
2080: x_resource_id
2081: FROM
2082: pa_resource_maps prm
2083: WHERE
2084: prm.resource_list_assignment_id = x_resource_list_assignment_id
2085: AND prm.resource_list_id = x_resource_list_id
2086: AND prm.expenditure_type = x_expenditure_type

Line 2105: pa_resource_maps prm

2101: INTO
2102: x_resource_list_member_id,
2103: x_resource_id
2104: FROM
2105: pa_resource_maps prm
2106: WHERE
2107: prm.resource_list_assignment_id = x_resource_list_assignment_id
2108: AND prm.resource_list_id = x_resource_list_id
2109: AND prm.expenditure_type = x_expenditure_type

Line 2129: pa_resource_maps prm

2125: INTO
2126: x_resource_list_member_id,
2127: x_resource_id
2128: FROM
2129: pa_resource_maps prm
2130: WHERE
2131: prm.resource_list_assignment_id = x_resource_list_assignment_id
2132: AND prm.resource_list_id = x_resource_list_id
2133: AND prm.event_type = x_event_type

Line 2163: pa_resource_maps;

2159:
2160: -- pa_debug.debug(x_err_stage);
2161: IF (x_resource_list_assignment_id is null) THEN
2162: DELETE
2163: pa_resource_maps;
2164: ELSE
2165: DELETE
2166: pa_resource_maps prm
2167: WHERE

Line 2166: pa_resource_maps prm

2162: DELETE
2163: pa_resource_maps;
2164: ELSE
2165: DELETE
2166: pa_resource_maps prm
2167: WHERE
2168: prm.resource_list_assignment_id = x_resource_list_assignment_id;
2169: END IF;
2170:

Line 2198: pa_resource_maps prm

2194:
2195: -- pa_debug.debug(x_err_stage);
2196:
2197: DELETE
2198: pa_resource_maps prm
2199: WHERE
2200: prm.resource_list_assignment_id IN
2201: ( SELECT
2202: resource_list_assignment_id

Line 2248: INSERT INTO pa_resource_maps

2244: --x_err_stage := 'Creating resource map';
2245:
2246: -- pa_debug.debug(x_err_stage);
2247:
2248: INSERT INTO pa_resource_maps
2249: (resource_list_id,
2250: resource_list_assignment_id,
2251: resource_list_member_id,
2252: resource_id,