APPS.PAY_ZA_ACB_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 34: from pay_payroll_actions ppa,

30: 'TRANSFER_PURGE_DATE=P', to_char(sysdate + 30, 'YYMMDD'),
31: 'TRANSFER_START_DATE=P', to_char(ppa.start_date, 'YYMMDD'),
32: 'TRANSFER_END_DATE=P', to_char(ppa.effective_date, 'YYMMDD'),
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

Line 49: INDEX (ppa2 PAY_PAYROLL_ACTIONS_PK)

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)
53: INDEX (ptp PER_TIME_PERIODS_PK)

Line 52: INDEX (ppa PAY_PAYROLL_ACTIONS_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),
56: 'TRANSFER_FIRST_ACTION_DATE=P', to_char(min(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date))), 'YYYYMMDD'),

Line 66: , pay_payroll_actions ppa2

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
70: , per_time_periods ptp

Line 69: , pay_payroll_actions ppa

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')
73: and paa.pre_payment_id = ppp.pre_payment_id

Line 94: select /*+ INDEX (ppa PAY_PAYROLL_ACTIONS_PK)

90:
91: -- ACB Contra-Transaction Header Cursor
92: --
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)

Line 102: INDEX (ppa2 PAY_PAYROLL_ACTIONS_PK)

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)
106: */

Line 116: from pay_payroll_actions ppa,

112: 'TRANSFER_ACTION_DATE=P', to_char(min(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date))), 'YYYYMMDD'),
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,

Line 124: pay_payroll_actions ppa2,

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
128: where