APPS.PAY_DK_SOE dependencies on PER_TIME_PERIODS

Line 227: , per_time_periods tp

223: l_action_type varchar2(2);
224: cursor periodDates is
225: select action_type from
226: pay_payroll_actions pa
227: , per_time_periods tp
228: , pay_assignment_actions aa
229: where pa.payroll_action_id = aa.payroll_action_id
230: and pa.effective_date = tp.regular_payment_date
231: and pa.payroll_id = tp.payroll_id

Line 253: ,per_time_periods tp1

249: ,tp1.period_type COL07
250: ,fnd_date.date_to_displaydate(tp1.DEFAULT_DD_DATE) COL08
251: from pay_payroll_actions pa1
252: ,pay_payroll_actions pa2
253: ,per_time_periods tp1
254: ,per_time_periods tp2
255: ,pay_assignment_actions aa1
256: ,pay_assignment_actions aa2
257: where pa1.payroll_action_id = aa1.payroll_action_id

Line 254: ,per_time_periods tp2

250: ,fnd_date.date_to_displaydate(tp1.DEFAULT_DD_DATE) COL08
251: from pay_payroll_actions pa1
252: ,pay_payroll_actions pa2
253: ,per_time_periods tp1
254: ,per_time_periods tp2
255: ,pay_assignment_actions aa1
256: ,pay_assignment_actions aa2
257: where pa1.payroll_action_id = aa1.payroll_action_id
258: and pa1.effective_date = tp1.regular_payment_date

Line 276: ,per_time_periods tp

272: ,fnd_date.date_to_displaydate(tp.start_date) COL02
273: ,tp.period_type COL07
274: ,fnd_date.date_to_displaydate(tp.DEFAULT_DD_DATE) COL08
275: from pay_payroll_actions pa
276: ,per_time_periods tp
277: ,pay_assignment_actions aa
278: where pa.payroll_action_id = aa.payroll_action_id
279: and pa.effective_date = tp.regular_payment_date
280: and pa.payroll_id = tp.payroll_id

Line 294: ,per_time_periods tp

290: ,fnd_date.date_to_displaydate(tp.start_date) COL02
291: ,tp.period_type COL07
292: ,fnd_date.date_to_displaydate(tp.DEFAULT_DD_DATE) COL08
293: from pay_payroll_actions pa
294: ,per_time_periods tp
295: ,pay_assignment_actions aa
296: where pa.payroll_action_id = aa.payroll_action_id
297: and pa.time_period_id = tp.time_period_id
298: and aa.assignment_action_id = :assignment_action_id';