DBA Data[Home] [Help]

APPS.PAY_NL_GENERAL dependencies on PAY_RUN_TYPES_F

Line 2970: FROM pay_run_types_f prt

2966: CURSOR csr_run_type(c_payroll_action_id NUMBER
2967: ,c_assignment_action_id NUMBER)
2968: IS
2969: SELECT prt.shortname
2970: FROM pay_run_types_f prt
2971: ,pay_payroll_actions ppa
2972: ,pay_assignment_actions paa
2973: WHERE ppa.payroll_action_id = c_payroll_action_id
2974: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2980: l_run_type pay_run_types_f.shortname%TYPE;

2976: AND paa.assignment_action_id = c_assignment_action_id
2977: AND ppa.effective_date BETWEEN prt.effective_start_date
2978: AND prt.effective_end_date;
2979:
2980: l_run_type pay_run_types_f.shortname%TYPE;
2981:
2982: BEGIN
2983:
2984: OPEN csr_run_type(p_payroll_action_id,p_assignment_action_id);