APPS.HR_WPM_UTIL dependencies on DUAL

Line 218: FROM DUAL

214: IS
215: CURSOR get_objectives_down (c_obj_id IN per_objectives.objective_id%TYPE)
216: IS
217: SELECT 'Y'
218: FROM DUAL
219: WHERE EXISTS (SELECT 'X'
220: FROM per_objectives
221: WHERE aligned_with_objective_id = c_obj_id); -- 8789635 bug fix changes
222:

Line 980: FROM DUAL

976:
977: CURSOR csr_plan_exists (p_person_id NUMBER, p_effective_date DATE)
978: IS
979: SELECT 'Y'
980: FROM DUAL
981: WHERE EXISTS (
982: SELECT NULL
983: FROM per_sp_plan plans, per_sp_successor_in_plan succ
984: WHERE plans.successee_id = p_person_id

Line 994: FROM DUAL

990:
991: CURSOR csr_is_a_successor (p_person_id NUMBER, p_effective_date DATE)
992: IS
993: SELECT 'Y'
994: FROM DUAL
995: WHERE EXISTS (
996: SELECT NULL
997: FROM per_sp_plan plans, per_sp_successor_in_plan succ
998: WHERE succ.successor_id = p_person_id

Line 1007: FROM SYS.DUAL

1003:
1004: CURSOR csr_active_employee (p_person_id NUMBER)
1005: IS
1006: SELECT 'Y'
1007: FROM SYS.DUAL
1008: WHERE EXISTS (
1009: SELECT NULL
1010: FROM per_person_types typ, per_person_type_usages_f ptu
1011: WHERE typ.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'APL'

Line 1242: FROM DUAL

1238: IS
1239: CURSOR csr_is_obj_open
1240: IS
1241: SELECT 'Y'
1242: FROM DUAL
1243: WHERE EXISTS (
1244: SELECT 'x'
1245: FROM per_personal_scorecards pps, per_assignments_f paf,
1246: per_perf_mgmt_plans pmp