DBA Data[Home] [Help]

APPS.PA_GET_RESOURCE dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1305: , pa_resource_assignments ra

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
1308: and rla.resource_list_id = bv.resource_list_id
1309: and bv.budget_version_id = ra.budget_version_id

Line 1316: from pa_resource_assignments ra

1312: SELECT 'x'
1313: FROM dual
1314: WHERE exists
1315: (select 'x'
1316: from pa_resource_assignments ra
1317: where ra.resource_list_member_id = l_resource_list_member_id);
1318:
1319: -- Check for Resource List Member Id in Pa_Fp_Elements
1320: