DBA Data[Home] [Help]

APPS.PAY_MX_PTU_CALC dependencies on DUAL

Line 421: FROM dual

417:
418: CURSOR c_chk_asg (cp_asg_set_id NUMBER,
419: cp_person_id NUMBER) IS
420: SELECT 'X'
421: FROM dual
422: WHERE (EXISTS(SELECT 'x'
423: FROM hr_assignment_set_amendments hasa
424: WHERE hasa.assignment_set_id = cp_asg_set_id
425: AND hasa.include_or_exclude = 'I')

Line 539: FROM dual

535: cp_start_date DATE,
536: cp_end_date DATE
537: ) IS
538: SELECT 'X'
539: FROM dual
540: WHERE NOT EXISTS(SELECT 'Y'
541: FROM per_assignments_f
542: WHERE assignment_id = cp_assignment_id
543: AND effective_start_date <= cp_end_date

Line 1014: FROM dual;

1010: lb_valid_pri_asg_found := TRUE;
1011:
1012: SELECT pay_assignment_actions_s.NEXTVAL
1013: INTO ln_PTU_action_id
1014: FROM dual;
1015:
1016: hr_nonrun_asact.insact(ln_PTU_action_id,
1017: ln_assignment_id,
1018: p_payroll_action_id,