APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_AU_ASG_ELEMENT_PAYMENTS_V

Line 73: hnainani 13-MAR-2007 120.3.1200000.5 5914696 Modified l_rate to get Rate from the view pay_au_asg_element_payments_v instead

69: priupadh 13-Feb-2006 120.5 5504354 Added cursors c_grade_step,c_pay_advice_date,c_get_bus_id in archive_employee_details
70: Added code to Archive additional Employee Details (Workchoice)
71: sclarke 23-Feb-2007 120.3.12000000.4
72: 5713447 Added new procedure archive_offset_payment_method(),it archives payment details for offset payrolls.
73: hnainani 13-MAR-2007 120.3.1200000.5 5914696 Modified l_rate to get Rate from the view pay_au_asg_element_payments_v instead
74: priupadh 02-JUL-2007 120.3.1200000.6 6032985 Modified csr_pay_advice_date , default direct entry (ptp.default_dd_date) needs to be displayed
75: as Payment Date in Payslip
76: vamittal 29-APR-2008 120.3.12000000.7 69623336 Modified archive_offset_payment_method() to be based on Prepayment Effective Date
77: jmarupil 08-JUN-2011 120.3.12000000.8 12625481 Added cursors csr_leave_taken6, csr_leave_taken7 for archive_absences procedure for displaying

Line 217: from pay_au_asg_element_payments_v

213: , classification_name
214: , SUM(payment) payment
215: , SUM( hours ) hours
216: , rate /* 5914696 */
217: from pay_au_asg_element_payments_v
218: where assignment_action_id = p_assignment_action_id
219: and classification_name is not null
220: group by element_reporting_name,rate,classification_name;
221: