APPS.PAY_ZA_ACB_TAPE dependencies on PER_TIME_PERIODS

Line 53: INDEX (ptp PER_TIME_PERIODS_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'),
57: 'TRANSFER_LAST_ACTION_DATE=P', to_char(max(nvl(ppa.overriding_dd_date, nvl(ptp.default_dd_date, ptp.end_date))), 'YYYYMMDD'),

Line 70: , per_time_periods ptp

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
74: and paa2.assignment_action_id =

Line 105: INDEX (ptp PER_TIME_PERIODS_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),
109: 'TRANSFER_ENTRY_CLASS=P', decode(pea2.segment2, '4', '64', '61'),

Line 127: per_time_periods ptp

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
131: and paa.pre_payment_id = ppp.pre_payment_id