APPS.PAY_AE_SOE dependencies on PER_TIME_PERIODS

Line 467: , per_time_periods tp

463: l_action_type varchar2(2);
464: cursor periodDates is
465: select action_type from
466: pay_payroll_actions pa
467: , per_time_periods tp
468: , pay_assignment_actions aa
469: where pa.payroll_action_id = aa.payroll_action_id
470: and pa.effective_date = tp.regular_payment_date
471: and pa.payroll_id = tp.payroll_id

Line 490: ,per_time_periods tp1

486: ,tp1.period_type COL07
487: , ppf.payroll_name COL10
488: from pay_payroll_actions pa1
489: ,pay_payroll_actions pa2
490: ,per_time_periods tp1
491: ,per_time_periods tp2
492: ,pay_assignment_actions aa1
493: ,pay_assignment_actions aa2
494: ,pay_all_payrolls_f ppf

Line 491: ,per_time_periods tp2

487: , ppf.payroll_name COL10
488: from pay_payroll_actions pa1
489: ,pay_payroll_actions pa2
490: ,per_time_periods tp1
491: ,per_time_periods tp2
492: ,pay_assignment_actions aa1
493: ,pay_assignment_actions aa2
494: ,pay_all_payrolls_f ppf
495: where pa1.payroll_action_id = aa1.payroll_action_id

Line 516: ,per_time_periods tp

512: ,fnd_date.date_to_displaydate(tp.start_date) COL02
513: ,tp.period_type COL07
514: ,ppf.payroll_name COL10
515: from pay_payroll_actions pa
516: ,per_time_periods tp
517: ,pay_assignment_actions aa
518: , pay_all_payrolls_f ppf
519: where pa.payroll_action_id = aa.payroll_action_id
520: and pa.effective_date = tp.regular_payment_date

Line 537: ,per_time_periods tp

533: ,fnd_date.date_to_displaydate(tp.start_date) COL02
534: ,tp.period_type COL07
535: ,ppf.payroll_name COL10
536: from pay_payroll_actions pa
537: ,per_time_periods tp
538: ,pay_assignment_actions aa
539: ,pay_all_payrolls_f ppf
540: where pa.payroll_action_id = aa.payroll_action_id
541: and pa.payroll_id = ppf.payroll_id