DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on FND_SESSIONS

Line 38: ** 22 Dec 2003 puchil 3306269 Removed fnd_sessions table in the header cursor to remove Cartesian joins.

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: */
42:

Line 183: , fnd_sessions s

179: , pay_run_result_values prrv1
180: , pay_run_result_values prrv2
181: , pay_assignment_actions assact
182: , pay_payroll_actions pact
183: , fnd_sessions s
184: , per_periods_of_service pos
185: , per_time_periods ptp
186: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
187: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')