APPS.PAY_MX_PTU_CALC dependencies on DUAL

Line 415: FROM dual

411:
412: CURSOR c_chk_asg (cp_asg_set_id NUMBER,
413: cp_person_id NUMBER) IS
414: SELECT 'X'
415: FROM dual
416: WHERE (EXISTS(SELECT 'x'
417: FROM hr_assignment_set_amendments hasa
418: WHERE hasa.assignment_set_id = cp_asg_set_id
419: AND hasa.include_or_exclude = 'I')

Line 529: FROM dual

525: CURSOR c_chk_asg_valid(cp_assignment_id NUMBER,
526: cp_effective_date DATE
527: ) IS
528: SELECT 'X'
529: FROM dual
530: WHERE NOT EXISTS(SELECT 'Y'
531: FROM per_assignments_f
532: WHERE assignment_id = cp_assignment_id
533: AND cp_effective_date BETWEEN effective_start_date

Line 979: FROM dual;

975: lb_valid_pri_asg_found := TRUE;
976:
977: SELECT pay_assignment_actions_s.NEXTVAL
978: INTO ln_PTU_action_id
979: FROM dual;
980:
981: hr_nonrun_asact.insact(ln_PTU_action_id,
982: ln_assignment_id,
983: p_payroll_action_id,