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_ASSIGNMENT_ACTIONS

Line 46: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)

42: -- ACB User Header Cursor
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)

Line 48: INDEX (paa2 PAY_ASSIGNMENT_ACTIONS_PK)

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)
52: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)

Line 63: pay_assignment_actions paa

59: 'TRANSFER_USER_REFERENCE=P', min(rpad(upper(scl.segment4),10,' ') || rpad(upper(scl.segment5), 20, ' ')),
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

Line 65: , pay_assignment_actions paa2

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
69: , pay_payroll_actions ppa

Line 97: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)

93: cursor acb_trans_header is
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)

Line 101: INDEX (paa2 PAY_ASSIGNMENT_ACTIONS_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)
103: INDEX (ppf PAY_PAYROLLS_F_PK)
104: INDEX (scl HR_SOFT_CODING_KEYFLEX_PK)
105: INDEX (ptp PER_TIME_PERIODS_PK)

Line 117: pay_assignment_actions paa,

113: 'TRANSFER_PAYROLL_NAME=P', substr(ppf.payroll_name, 1, 80),
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,

Line 123: pay_assignment_actions paa2,

119: pay_org_payment_methods_f opm,
120: pay_external_accounts pea,
121: pay_personal_payment_methods_f ppm,
122: pay_external_accounts pea2,
123: pay_assignment_actions paa2,
124: pay_payroll_actions ppa2,
125: pay_all_payrolls_f ppf,
126: hr_soft_coding_keyflex scl,
127: per_time_periods ptp

Line 187: pay_assignment_actions paa,

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')
190: and paa.assignment_id = paf.assignment_id
191: and paf.payroll_id + 0 = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ID')