DBA Data[Home] [Help]

APPS.PA_RESOURCE_MAPPING dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 1321: FROM pa_resource_lists_all_bg

1317: --creation or is it centrally controlled
1318: BEGIN
1319: SELECT CONTROL_FLAG, nvl(resource_class_flag, 'Y')
1320: INTO g_control_flag, g_resource_class_flag
1321: FROM pa_resource_lists_all_bg
1322: WHERE RESOURCE_LIST_ID = p_resource_list_id;
1323: EXCEPTION
1324: WHEN NO_DATA_FOUND THEN
1325: NULL;

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

1429:
1430:
1431: /* added for bug#4027727 */
1432: BEGIN
1433: SELECT job_group_id INTO l_job_group_id FROM pa_resource_lists_all_bg WHERE resource_list_id = p_resource_list_id ;
1434: EXCEPTION
1435: WHEN NO_DATA_FOUND THEN
1436: NULL;
1437: END;