[Home] [Help]
80: and paa2.payroll_action_id = ppa2.payroll_action_id
81: and ppa2.payroll_id = ppf.payroll_id
82: and ppa2.effective_date between ppf.effective_start_date and ppf.effective_end_date
83: and ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
84: and scl.id_flex_num = (select rule_mode from pay_legislation_rules where legislation_code = 'ZA' and rule_type = 'S')
85: and scl.enabled_flag = 'Y'
86: and paa.payroll_action_id = ppa.payroll_action_id
87: and ppa2.time_period_id = ptp.time_period_id
88: group by substr(scl.segment2, 1, 80)
132: and ppp.org_payment_method_id = opm.org_payment_method_id
133: and ppa.effective_date between opm.effective_start_date
134: and opm.effective_end_date
135: and opm.external_account_id = pea.external_account_id
136: and pea.id_flex_num = (Select rule_mode from pay_legislation_rules WHERE LEGISLATION_CODE = 'ZA' and rule_type = 'E')
137: and pea.enabled_flag = 'Y'
138:
139: and ppp.personal_payment_method_id = ppm.personal_payment_method_id
140: and ppa.effective_date between ppm.effective_start_date
152: and ppf.effective_end_date
153: and ppa2.business_group_id = ppf.business_group_id
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,
184: pay_personal_payment_methods ppm,
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