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.date_earned between tp.start_date and tp.end_date /* 9178309 */

Line 491: ,per_time_periods tp1

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

Line 492: ,per_time_periods tp2

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

Line 519: ,per_time_periods tp

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

Line 541: ,per_time_periods tp

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