APPS.PAY_ZA_ACB_TAPE dependencies on HR_SOFT_CODING_KEYFLEX

Line 51: INDEX (scl HR_SOFT_CODING_KEYFLEX_PK)

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)
53: INDEX (ptp PER_TIME_PERIODS_PK)
54: */
55: 'TRANSFER_ACB_USER_CODE=P', substr(scl.segment2, 1, 80),

Line 68: , hr_soft_coding_keyflex scl

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
70: , per_time_periods ptp
71: where
72: paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 104: INDEX (scl HR_SOFT_CODING_KEYFLEX_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)
106: */
107: distinct 'TRANSFER_ORG_PAY_METHOD=P', ppp.org_payment_method_id,
108: 'TRANSFER_USER_BRANCH=P', substr(pea.segment1, 1, 80),

Line 126: hr_soft_coding_keyflex scl,

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
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