APPS.PA_RESOURCE_MAPPING dependencies on PA_PLAN_RL_FORMATS

Line 1305: FROM pa_plan_rl_formats

1301: BEGIN
1302: SELECT RES_FORMAT_ID
1303: BULK COLLECT
1304: INTO l_res_list_formats
1305: FROM pa_plan_rl_formats
1306: WHERE RESOURCE_LIST_ID = p_resource_list_id;
1307: EXCEPTION
1308: WHEN NO_DATA_FOUND THEN
1309: NULL;

Line 1367: FROM PA_ACT_PRL_PRECEDENCE prec, pa_plan_rl_formats prl

1363: ELSE
1364:
1365: SELECT prec.EFF_RES_FORMAT_ID, prec.RES_PREC_ID
1366: bulk collect INTO l_eff_formats, l_res_prec_id
1367: FROM PA_ACT_PRL_PRECEDENCE prec, pa_plan_rl_formats prl
1368: WHERE prl.RESOURCE_LIST_ID = p_resource_list_id
1369: AND prl.RES_FORMAT_ID = prec.RES_FORMAT_ID
1370: AND prec.res_class_type = 'ONE'
1371: ORDER BY res_prec_id;