APPS.PA_RESOURCE_MAPPING dependencies on DUAL

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

725: RETURN TRUE;
726: END IF; */
727: -- Commented this as part of bug fix :4350603
728: SELECT 1
729: INTO l_count FROM dual WHERE EXISTS (SELECT 1
730: FROM pa_res_list_map_tmp1);
731: RETURN TRUE;
732: EXCEPTION WHEN NO_DATA_FOUND THEN
733: RETURN FALSE;

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

1195: END;
1196: IF l_job_group_id IS NOT NULL THEN
1197: UPDATE pa_res_list_map_tmp1 tmp1
1198: SET tmp1.job_id =
1199: (SELECT PA_Cross_Business_Grp.IsMappedToJob(tmp1.job_id, l_job_group_id) FROM DUAL)
1200: WHERE tmp1.job_id IS NOT NULL;
1201: END IF;
1202:
1203: --Process mapping logic for every format (based on eff_res_format_id)