[Home] [Help]
34: ** 28 May 2002 Ragovind 2381433 Changed the c_detail cursor for employee having a payroll with +ve offset
35: ** 08 Nov 2002 Apunekar 2600912 Removed redundant columns as per the view changes.
36: ** 17 Jan 2002 srrajago 2755544 Included negative value check for student_loan_deduction in c_detail cursor.
37: ** 30 May 2002 puchil 2920728 Changed both the cursors to use secured views.
38: ** 22 Dec 2003 puchil 3306269 Removed fnd_sessions table in the header cursor to remove Cartesian joins.
39: ** 12-Apr-2007 dduvvuri 5846247 Modified header and detail cursors for KiwiSaver Requirement
40: ** 24-Apr-2007 dduvvuri 5846247 Modified spellings for certain Formula parameters req by KiwiSaver
41: ** 06-Nov-2008 dduvvuri 7480679 Modified c_detail cursor
42: ** 07-Nov-2008 dduvvuri 7480679 Modified c_detail cursor after review comments.
226: , pay_run_result_values prrv1
227: -- , pay_run_result_values prrv2 /* 7480679 */
228: , pay_assignment_actions assact
229: , pay_payroll_actions pact
230: , fnd_sessions s
231: , per_periods_of_service pos
232: , per_time_periods ptp
233: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
234: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')