DBA Data[Home] [Help]

APPS.PAY_ES_RULES dependencies on PER_TIME_PERIODS

Line 119: ,per_time_periods ptp

115: ,pay_input_values_f piv
116: ,pay_element_types_f pet
117: ,pay_assignment_actions paa
118: ,pay_payroll_actions ppa
119: ,per_time_periods ptp
120: WHERE paa.assignment_action_id = p_assignment_action_id
121: AND ppa.payroll_action_id = paa.payroll_action_id
122: AND ppa.payroll_id = ptp.payroll_id
123: AND ppa.time_period_id = ptp.time_period_id

Line 163: ,per_time_periods ptp

159: ,pay_input_values_f piv
160: ,pay_element_types_f pet
161: ,pay_assignment_actions paa
162: ,pay_payroll_actions ppa
163: ,per_time_periods ptp
164: WHERE paa.assignment_action_id = p_assignment_action_id
165: AND ppa.payroll_action_id = paa.payroll_action_id
166: AND ppa.payroll_id = ptp.payroll_id
167: AND ppa.time_period_id = ptp.time_period_id