eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_EMS dependencies on PAY_MAGTAPE_GENERIC

Line 90: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')

86: , 'notprinted'
87: from hr_organization_units ou /*Bug No 2920728*/
88: , hr_organization_information oi
89: , pay_nz_er_cal_mth_bal_v b
90: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
91: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
92: and oi.organization_id = ou.organization_id
93: and oi.org_information_context = 'NZ_IRD_EMPLOYER'
94: and b.organization_id = to_char(ou.organization_id) ;

Line 91: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

87: from hr_organization_units ou /*Bug No 2920728*/
88: , hr_organization_information oi
89: , pay_nz_er_cal_mth_bal_v b
90: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
91: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
92: and oi.organization_id = ou.organization_id
93: and oi.org_information_context = 'NZ_IRD_EMPLOYER'
94: and b.organization_id = to_char(ou.organization_id) ;
95:

Line 186: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')

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')
188: and b.organization_id = to_char(ou.organization_id)
189: and p.effective_start_date <= last_day(s.effective_date)
190: and p.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')

Line 187: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

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')
188: and b.organization_id = to_char(ou.organization_id)
189: and p.effective_start_date <= last_day(s.effective_date)
190: and p.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
191: -- the following sub query makes sure that we get the person record in effect at the end of the month