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

Line 37: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

33: 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id
34: from pay_payroll_actions ppa,
35: hr_organization_information hoi,
36: hr_organization_units hou
37: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
38: and hou.organization_id = ppa.business_group_id
39: and hoi.organization_id = hou.organization_id
40: and hoi.org_information_context = 'ZA_ACB_INFORMATION';
41:

Line 72: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

68: , hr_soft_coding_keyflex scl
69: , pay_payroll_actions ppa
70: , per_time_periods ptp
71: where
72: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
73: and paa.pre_payment_id = ppp.pre_payment_id
74: and paa2.assignment_action_id =
75: (
76: select max(locked_action_id)

Line 129: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

125: pay_all_payrolls_f ppf,
126: hr_soft_coding_keyflex scl,
127: per_time_periods ptp
128: where
129: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
130: and ppa.payroll_action_id = paa.payroll_action_id
131: and paa.pre_payment_id = ppp.pre_payment_id
132: and ppp.org_payment_method_id = opm.org_payment_method_id
133: and ppa.effective_date between opm.effective_start_date

Line 158: and scl.segment2 = pay_magtape_generic.get_parameter_value('TRANSFER_ACB_USER_CODE')

154: and ppa2.payroll_id = ppf.payroll_id
155: and ppf.soft_coding_keyflex_id + 0 = scl.soft_coding_keyflex_id
156: and scl.id_flex_num = (SELECT rule_mode FROM pay_legislation_rules WHERE LEGISLATION_CODE = 'ZA' and rule_type = 'S')
157: and scl.enabled_flag = 'Y'
158: and scl.segment2 = pay_magtape_generic.get_parameter_value('TRANSFER_ACB_USER_CODE')
159: group by ppp.org_payment_method_id,
160: pea.segment1,
161: decode(pea2.segment2, '4', '64', '61'),
162: pea.segment3,

Line 189: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

185: pay_pre_payments ppp,
186: per_all_assignments paf,
187: pay_assignment_actions paa,
188: pay_legislation_rules plr
189: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
190: and paa.assignment_id = paf.assignment_id
191: and paf.payroll_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ID')
192: and paf.person_id = ppf.person_id
193: and ppp.org_payment_method_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

Line 191: and paf.payroll_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ID')

187: pay_assignment_actions paa,
188: pay_legislation_rules plr
189: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
190: and paa.assignment_id = paf.assignment_id
191: and paf.payroll_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ID')
192: and paf.person_id = ppf.person_id
193: and ppp.org_payment_method_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
194: and ppp.pre_payment_id = paa.pre_payment_id
195: and ppm.personal_payment_method_id = ppp.personal_payment_method_id

Line 193: and ppp.org_payment_method_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')

189: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
190: and paa.assignment_id = paf.assignment_id
191: and paf.payroll_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ID')
192: and paf.person_id = ppf.person_id
193: and ppp.org_payment_method_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
194: and ppp.pre_payment_id = paa.pre_payment_id
195: and ppm.personal_payment_method_id = ppp.personal_payment_method_id
196: and decode(pea.segment2, '4', '64', '61') = pay_magtape_generic.get_parameter_value('TRANSFER_ENTRY_CLASS')
197: and pea.external_account_id = ppm.external_account_id

Line 196: and decode(pea.segment2, '4', '64', '61') = pay_magtape_generic.get_parameter_value('TRANSFER_ENTRY_CLASS')

192: and paf.person_id = ppf.person_id
193: and ppp.org_payment_method_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD')
194: and ppp.pre_payment_id = paa.pre_payment_id
195: and ppm.personal_payment_method_id = ppp.personal_payment_method_id
196: and decode(pea.segment2, '4', '64', '61') = pay_magtape_generic.get_parameter_value('TRANSFER_ENTRY_CLASS')
197: and pea.external_account_id = ppm.external_account_id
198: and pea.id_flex_num = plr.rule_mode
199: and plr.LEGISLATION_CODE = 'ZA'
200: and plr.rule_type = 'E'