APPS.PAY_IN_SOE_PKG dependencies on PER_TIME_PERIODS

Line 195: ,per_time_periods tp

191:
192: CURSOR periodDates IS
193: SELECT action_type FROM
194: pay_payroll_actions pa
195: ,per_time_periods tp
196: ,pay_assignment_actions aa
197: WHERE pa.payroll_action_id = aa.payroll_action_id
198: AND pa.effective_date = tp.regular_payment_date
199: AND pa.payroll_id = tp.payroll_id

Line 223: ,per_time_periods tp1

219: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
220: ,tp1.period_type COL07
221: from pay_payroll_actions pa1
222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1
226: ,pay_assignment_actions aa2
227: where pa1.payroll_action_id = aa1.payroll_action_id

Line 224: ,per_time_periods tp2

220: ,tp1.period_type COL07
221: from pay_payroll_actions pa1
222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1
226: ,pay_assignment_actions aa2
227: where pa1.payroll_action_id = aa1.payroll_action_id
228: and pa1.effective_date = tp1.regular_payment_date

Line 245: ,per_time_periods tp

241: ,fnd_date.date_to_displaydate(aa.end_date) COL06
242: ,fnd_date.date_to_displaydate(tp.start_date) COL02
243: ,tp.period_type COL07
244: from pay_payroll_actions pa
245: ,per_time_periods tp
246: ,pay_assignment_actions aa
247: where pa.payroll_action_id = aa.payroll_action_id
248: and pa.effective_date = tp.regular_payment_date
249: and pa.payroll_id = tp.payroll_id

Line 262: ,per_time_periods tp

258: ,fnd_date.date_to_displaydate(aa.end_date) COL06
259: ,fnd_date.date_to_displaydate(tp.start_date) COL02
260: ,tp.period_type COL07
261: from pay_payroll_actions pa
262: ,per_time_periods tp
263: ,pay_assignment_actions aa
264: where pa.payroll_action_id = aa.payroll_action_id
265: and pa.time_period_id = tp.time_period_id
266: and aa.assignment_action_id = :assignment_action_id';

Line 1047: ,per_time_periods ptp

1043: FROM pay_assignment_actions paa
1044: ,pay_payroll_actions ppa
1045: ,pay_run_results prr
1046: ,pay_run_result_values prrv
1047: ,per_time_periods ptp
1048: ,pay_element_types_f pet
1049: ,pay_input_values_f piv
1050: ,pay_element_entries_f pee
1051: ,per_absence_attendance_types pat