DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on PER_TIME_PERIODS

Line 169: ,per_time_periods ptp

165: FROM pay_assignment_actions paa
166: ,pay_payroll_actions ppa
167: ,hr_lookups hrl
168: ,pay_action_information pai
169: ,per_time_periods ptp
170: WHERE paa.assignment_id = c_assignment_id
171: AND paa.payroll_action_id = ppa.payroll_action_id
172: AND paa.source_action_id IS NULL
173: AND ppa.effective_Date BETWEEN c_start_date

Line 205: ,per_time_periods ptp

201: ,pay_payroll_actions ppa
202: ,hr_lookups hrl
203: ,hr_assignment_set_amendments hasa
204: ,pay_action_information pai
205: ,per_time_periods ptp
206: WHERE paa.assignment_id = c_assignment_id
207: AND paa.payroll_action_id = ppa.payroll_action_id
208: AND paa.source_action_id IS NULL
209: AND ppa.effective_Date BETWEEN c_start_date