DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on DUAL

Line 463: SELECT 1 FROM dual

459: CURSOR c_non_zero_run_result(cp_business_group number,
460: cp_assignment_id number,
461: cp_effective_date date,
462: cp_tax_unit_id number) is
463: SELECT 1 FROM dual
464: WHERE EXISTS (SELECT 1
465: FROM pay_run_results prr,
466: pay_run_result_values prrv,
467: pay_input_values_f piv,

Line 519: FROM dual;

515: WHERE person_id = c_person_id;
516:
517: CURSOR c_assignment_set_id IS
518: SELECT hr_assignment_sets_s.nextval
519: FROM dual;
520:
521: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2) IS
522: SELECT assignment_set_id
523: FROM hr_assignment_sets