DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_RUN_TYPES_F

Line 656: ,pay_run_types_f prt

652: CURSOR csr_get_effective_date IS
653: SELECT ppa.effective_date
654: ,prt.shortname
655: FROM pay_payroll_actions ppa
656: ,pay_run_types_f prt
657: WHERE ppa.payroll_action_id = p_payroll_action_id
658: AND ppa.run_type_id = prt.run_type_id
659: AND ppa.effective_date BETWEEN prt.effective_start_date
660: AND prt.effective_end_date;

Line 1094: ,pay_run_types_f prtf

1090: ,prtf.shortname
1091: FROM pay_payroll_actions ppa
1092: ,pay_assignment_actions paa
1093: ,per_all_assignments_f paaf
1094: ,pay_run_types_f prtf
1095: WHERE ppa.payroll_action_id = p_payroll_action_id
1096: AND ppa.payroll_action_id = paa.payroll_action_id
1097: AND ppa.run_type_id = prtf.run_type_id
1098: AND paaf.assignment_id = paa.assignment_id