DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_REPORT dependencies on PER_TIME_PERIODS

Line 173: ,per_time_periods ptp

169: FROM pay_assignment_actions paa
170: ,pay_payroll_actions ppa
171: ,hr_lookups hrl
172: ,pay_action_information pai
173: ,per_time_periods ptp
174: WHERE paa.assignment_id = c_assignment_id
175: AND paa.payroll_action_id = ppa.payroll_action_id
176: AND paa.source_action_id IS NULL
177: AND ppa.effective_Date BETWEEN c_start_date

Line 211: ,per_time_periods ptp

207: ,pay_payroll_actions ppa
208: ,hr_lookups hrl
209: ,hr_assignment_set_amendments hasa
210: ,pay_action_information pai
211: ,per_time_periods ptp
212: WHERE paa.assignment_id = c_assignment_id
213: AND paa.payroll_action_id = ppa.payroll_action_id
214: AND paa.source_action_id IS NULL
215: AND ppa.effective_Date BETWEEN c_start_date