DBA Data[Home] [Help]

APPS.PA_GET_RESOURCE dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 1151: from pa_resource_list_assignments rla

1147: SELECT 'x'
1148: FROM dual
1149: WHERE exists
1150: (select 'x'
1151: from pa_resource_list_assignments rla
1152: where rla.resource_list_id = l_resource_list_id);
1153:
1154: -- Check for Resource List in Project Types All
1155:

Line 1287: from pa_resource_list_assignments rla, pa_project_accum_headers pah

1283: SELECT 'x'
1284: FROM dual
1285: WHERE exists
1286: (select 'x'
1287: from pa_resource_list_assignments rla, pa_project_accum_headers pah
1288: where rla.resource_list_id = l_resource_list_id
1289: and rla.project_id = pah.project_id
1290: and rla.resource_list_id = pah.resource_list_id
1291: and pah.resource_list_member_id = l_resource_list_member_id);

Line 1303: from pa_resource_list_assignments rla

1299: SELECT 'x'
1300: FROM dual
1301: WHERE exists
1302: (select 'x'
1303: from pa_resource_list_assignments rla
1304: , pa_budget_versions bv
1305: , pa_resource_assignments ra
1306: where rla.resource_list_id = l_resource_list_id
1307: and rla.project_id = bv.project_id