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_ZA_IRP5_MAGTAPE_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 33: and pay_magtape_generic.get_parameter_value('BUS_GRP') = hoi.organization_id;

29: from hr_all_organization_units haou,
30: hr_organization_information hoi
31: where hoi.organization_id = haou.organization_id
32: and hoi.org_information_context = 'ZA_TAX_FILE_ENTITY'
33: and pay_magtape_generic.get_parameter_value('BUS_GRP') = hoi.organization_id;
34:
35: -- The driving cursor for the Employer Header
36: -- Note: TRANSFER_PAYROLL_ACTION_ID is the optional Payroll Action ID parameter
37: -- on the Electronic Tax File Magtape SRS. If supplied it is the Payroll

Line 53: and pay_magtape_generic.get_parameter_value('BUS_GRP') = haou.business_group_id

49: from hr_all_organization_units haou,
50: hr_organization_information hoi,
51: hr_locations hloc
52: where hoi.organization_id = haou.organization_id
53: and pay_magtape_generic.get_parameter_value('BUS_GRP') = haou.business_group_id
54: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'
55: and hloc.location_id (+) = haou.location_id
56: and exists
57: (

Line 63: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),

59: from pay_payroll_actions ppa,
60: pay_assignment_actions paa,
61: per_assignment_extra_info paei
62: where ppa.payroll_action_id =
63: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
64: ppa.payroll_action_id)
65: and ppa.action_type = 'X'
66: and ppa.report_type = 'ZA_IRP5'
67: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',

Line 69: pay_magtape_generic.get_parameter_value('TAX_YEAR')

65: and ppa.action_type = 'X'
66: and ppa.report_type = 'ZA_IRP5'
67: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',
68: ppa.legislative_parameters) =
69: pay_magtape_generic.get_parameter_value('TAX_YEAR')
70: and paa.payroll_action_id = ppa.payroll_action_id
71: and paa.assignment_id = paei.assignment_id
72: and to_char(haou.organization_id) = paei.aei_information7
73: and paei.aei_information_category = 'ZA_SPECIFIC_INFO'

Line 126: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),

122: ff_archive_item_contexts faidn,
123: ff_contexts fc1,
124: ff_database_items fdi
125: where ppa.payroll_action_id =
126: nvl(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
127: ppa.payroll_action_id)
128: and ppa.action_type = 'X'
129: and ppa.report_type = 'ZA_IRP5'
130: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR', ppa.legislative_parameters) =

Line 131: pay_magtape_generic.get_parameter_value('TAX_YEAR')

127: ppa.payroll_action_id)
128: and ppa.action_type = 'X'
129: and ppa.report_type = 'ZA_IRP5'
130: and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR', ppa.legislative_parameters) =
131: pay_magtape_generic.get_parameter_value('TAX_YEAR')
132: and paa.payroll_action_id = ppa.payroll_action_id
133: and paa.assignment_id = paei.assignment_id
134: and paa.serial_number is not null
135: and py_za_tax_certificates.irp5_indicator(paa.assignment_action_id) in ('Y','N') -- 6166892

Line 164: pay_magtape_generic.get_parameter_value('TRANSFER_LEG_ENTITY_ID')

160: and papf2.payroll_id = pef.payroll_id
161: )
162: and scl.soft_coding_keyflex_id (+) = papf.soft_coding_keyflex_id
163: and paei.aei_information7 =
164: pay_magtape_generic.get_parameter_value('TRANSFER_LEG_ENTITY_ID')
165: and paei.aei_information_category = 'ZA_SPECIFIC_INFO'
166: AND fai.context1 = paa.assignment_action_id
167: and fc1.context_name = 'SOURCE_TEXT'
168: and faidn.context_id = fc1.context_id

Line 197: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')

193: ff_contexts fc2,
194: pay_za_irp5_bal_codes code,
195: ff_database_items fdi
196: where fai.context1 =
197: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')
198: and fc2.context_name = 'SOURCE_NUMBER'
199: and faic2.context_id = fc2.context_id
200: and fai.archive_item_id = faic2.archive_item_id
201: AND fdi.user_entity_id = fai.user_entity_id

Line 228: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')

224: ff_archive_items fai,
225: pay_za_irp5_bal_codes code,
226: ff_database_items fdi
227: Where fai.context1 =
228: pay_magtape_generic.get_parameter_value('TRANSFER_ASSIGNMENT_ACTION_ID')
229: AND fdi.user_entity_id = fai.user_entity_id
230: AND fdi.user_name = code.user_name
231: And code.user_name in
232: (