APPS.PA_RESOURCE_MAPPING dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 1096: FROM pa_resource_lists_all_bg

1092: --creation or is it centrally controlled
1093: BEGIN
1094: SELECT CONTROL_FLAG
1095: INTO g_control_flag
1096: FROM pa_resource_lists_all_bg
1097: WHERE RESOURCE_LIST_ID = p_resource_list_id;
1098: EXCEPTION
1099: WHEN NO_DATA_FOUND THEN
1100: NULL;

Line 1191: SELECT job_group_id INTO l_job_group_id FROM pa_resource_lists_all_bg WHERE resource_list_id = p_resource_list_id ;

1187:
1188:
1189: /* added for bug#4027727 */
1190: BEGIN
1191: SELECT job_group_id INTO l_job_group_id FROM pa_resource_lists_all_bg WHERE resource_list_id = p_resource_list_id ;
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: NULL;
1195: END;