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 127: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')

123: , 'notprinted'
124: from hr_organization_units ou /*Bug No 2920728*/
125: , hr_organization_information oi
126: , pay_nz_er_cal_mth_bal_v b
127: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
128: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
129: and oi.organization_id = ou.organization_id
130: and oi.org_information_context = 'NZ_IRD_EMPLOYER'
131: and b.organization_id = to_char(ou.organization_id) ;

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

124: from hr_organization_units ou /*Bug No 2920728*/
125: , hr_organization_information oi
126: , pay_nz_er_cal_mth_bal_v b
127: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
128: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
129: and oi.organization_id = ou.organization_id
130: and oi.org_information_context = 'NZ_IRD_EMPLOYER'
131: and b.organization_id = to_char(ou.organization_id) ;
132:

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

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

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

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