[Home] [Help]
43: --
44: cursor acb_user_header is
45: select /*+ ORDERED
46: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)
47: INDEX (ppp PAY_PRE_PAYMENTS_PK)
48: INDEX (paa2 PAY_ASSIGNMENT_ACTIONS_PK)
49: INDEX (ppa2 PAY_PAYROLL_ACTIONS_PK)
50: INDEX (ppf PAY_PAYROLLS_F_PK)
51: INDEX (scl HR_SOFT_CODING_KEYFLEX_PK)
60: 'TRANSFER_AGGREGATE_LIMIT=P', nvl(min(substr(scl.segment6, 1, 80)), '0'),
61: 'TRANSFER_ITEM_LIMIT=P', nvl(min(substr(scl.segment7, 1, 80)), '0')
62: from
63: pay_assignment_actions paa
64: , pay_pre_payments ppp
65: , pay_assignment_actions paa2
66: , pay_payroll_actions ppa2
67: , pay_payrolls_f ppf
68: , hr_soft_coding_keyflex scl
94: select /*+ INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
95: INDEX (opm PAY_ORG_PAYMENT_METHODS_F_PK)
96: INDEX (pea PAY_EXTERNAL_ACCOUNTS_PK)
97: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)
98: INDEX (ppp PAY_PRE_PAYMENTS_PK)
99: INDEX (ppm PAY_PERSONAL_PAYMENT_METHO_PK)
100: INDEX (pea2 PAY_EXTERNAL_ACCOUNTS_PK)
101: INDEX (paa2 PAY_ASSIGNMENT_ACTIONS_PK)
102: INDEX (ppa2 PAY_PAYROLL_ACTIONS_PK)
114: 'TRANSFER_PAYROLL_ID=P', ppf.payroll_id,
115: 'TRANSFER_PAY_METHOD_NAME=P', substr(opm.org_payment_method_name, 1, 80)
116: from pay_payroll_actions ppa,
117: pay_assignment_actions paa,
118: pay_pre_payments ppp,
119: pay_org_payment_methods_f opm,
120: pay_external_accounts pea,
121: pay_personal_payment_methods_f ppm,
122: pay_external_accounts pea2,
181: 'TRANSFER_HOMING_ACC_NAME=P', nvl(upper(substr(pea.segment4, 1, 80)), upper(substr(ppf.last_name, 1, 80)) || ' ' || substr(upper(ppf.first_name), 1, 1))
182: from per_all_people ppf,
183: pay_external_accounts pea,
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')