73: --
74: CURSOR get_dp_period(c_pay_act_id NUMBER) IS
75: select ptp.start_date
76: ,ptp.end_date
77: from pay_payroll_actions ppa
78: ,per_time_periods ptp
79: where ppa.payroll_action_id = c_pay_act_id
80: AND ptp.time_period_id = ppa.time_period_id;
81: --
83: ,c_start_date DATE
84: ,c_end_date DATE) IS
85: select paa.assignment_action_id
86: from pay_assignment_actions paa
87: ,pay_payroll_actions ppa
88: where paa.assignment_id = c_assignment_id
89: and paa.payroll_action_id = ppa.payroll_action_id
90: AND ppa.action_type IN ('Q','R')
91: AND ppa.action_status in ('C','P')