APPS.PA_RESOURCE_MAPPING dependencies on PA_ACT_PRL_PRECEDENCE

Line 326: FROM PA_ACT_PRL_PRECEDENCE prec

322: g_res_format_id := l_format.res_format_id;
323: ELSE
324: SELECT prec.res_tokens, res_format_id
325: INTO l_token_string, g_res_format_id
326: FROM PA_ACT_PRL_PRECEDENCE prec
327: WHERE prec.EFF_RES_FORMAT_ID = p_eff_res_format_id
328: AND prec.res_prec_id = g_res_prec_id;
329: END IF;
330:

Line 1137: from PA_ACT_PRL_PRECEDENCE a, pa_Res_formats_b b

1133: END IF;
1134: begin
1135: select b.resource_class_id
1136: into l_res_class_id
1137: from PA_ACT_PRL_PRECEDENCE a, pa_Res_formats_b b
1138: where a.res_prec_id = g_res_prec_id
1139: and a.eff_res_format_id = p_format_id
1140: and b.res_format_id = a.res_format_id;
1141:

Line 1187: FROM pa_Res_formats_b b,PA_RESOURCE_CLASSES_B c, PA_ACT_PRL_PRECEDENCE d

1183:
1184: UPDATE pa_res_list_map_tmp3 a
1185: SET ( a.RESOURCE_CLASS_ID,a.RESOURCE_CLASS_CODE)
1186: = (SELECT c.resource_class_id ,c.resource_class_code
1187: FROM pa_Res_formats_b b,PA_RESOURCE_CLASSES_B c, PA_ACT_PRL_PRECEDENCE d
1188: WHERE b.resource_class_id = c.resource_class_id
1189: AND a.res_format_id = b.res_format_id
1190: AND b.res_format_id = d.res_format_id
1191: AND d.res_prec_id = g_res_prec_id

Line 1196: FROM pa_Res_formats_b b1,PA_RESOURCE_CLASSES_B c1, PA_ACT_PRL_PRECEDENCE d1

1192: and d.eff_res_format_id = p_format_id
1193: )
1194: WHERE EXISTS (
1195: SELECT 'x'
1196: FROM pa_Res_formats_b b1,PA_RESOURCE_CLASSES_B c1, PA_ACT_PRL_PRECEDENCE d1
1197: WHERE b1.resource_class_id = c1.resource_class_id
1198: AND b1.res_format_id = d1.res_format_id
1199: AND a.res_format_id = b1.res_format_id
1200: AND d1.res_prec_id = g_res_prec_id

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;