APPS.PA_RESOURCE_MAPPING dependencies on PA_RES_FORMATS_B

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