APPS.PA_RESOURCE_MAPPING dependencies on DUAL

Line 831: INTO l_count FROM dual WHERE EXISTS (SELECT 1

827: RETURN TRUE;
828: END IF; */
829: -- Commented this as part of bug fix :4350603
830: SELECT 1
831: INTO l_count FROM dual WHERE EXISTS (SELECT 1
832: FROM pa_res_list_map_tmp1);
833: RETURN TRUE;
834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: RETURN FALSE;

Line 1272: FROM dual

1268: pa_resource_classes_b
1269: WHERE g_resource_class_flag = 'Y'
1270: UNION
1271: SELECT 1
1272: FROM dual
1273: WHERE g_resource_class_flag = 'N' ;
1274:
1275: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

Line 1441: (SELECT PA_Cross_Business_Grp.IsMappedToJob(tmp1.job_id, l_job_group_id) FROM DUAL)

1437: END;
1438: IF l_job_group_id IS NOT NULL THEN
1439: UPDATE pa_res_list_map_tmp1 tmp1
1440: SET tmp1.job_id =
1441: (SELECT PA_Cross_Business_Grp.IsMappedToJob(tmp1.job_id, l_job_group_id) FROM DUAL)
1442: WHERE tmp1.job_id IS NOT NULL;
1443: END IF;
1444:
1445: --Process mapping logic for every format (based on eff_res_format_id)