APPS.PAY_KW_SOE dependencies on PER_TIME_PERIODS

Line 457: , per_time_periods tp

453: l_action_type varchar2(2);
454: cursor periodDates is
455: select action_type from
456: pay_payroll_actions pa
457: , per_time_periods tp
458: , pay_assignment_actions aa
459: where pa.payroll_action_id = aa.payroll_action_id
460: and pa.effective_date = tp.regular_payment_date
461: and pa.payroll_id = tp.payroll_id

Line 480: ,per_time_periods tp1

476: ,tp1.period_type COL07
477: , ppf.payroll_name COL10
478: from pay_payroll_actions pa1
479: ,pay_payroll_actions pa2
480: ,per_time_periods tp1
481: ,per_time_periods tp2
482: ,pay_assignment_actions aa1
483: ,pay_assignment_actions aa2
484: ,pay_all_payrolls_f ppf

Line 481: ,per_time_periods tp2

477: , ppf.payroll_name COL10
478: from pay_payroll_actions pa1
479: ,pay_payroll_actions pa2
480: ,per_time_periods tp1
481: ,per_time_periods tp2
482: ,pay_assignment_actions aa1
483: ,pay_assignment_actions aa2
484: ,pay_all_payrolls_f ppf
485: where pa1.payroll_action_id = aa1.payroll_action_id

Line 506: ,per_time_periods tp

502: ,fnd_date.date_to_displaydate(tp.start_date) COL02
503: ,tp.period_type COL07
504: ,ppf.payroll_name COL10
505: from pay_payroll_actions pa
506: ,per_time_periods tp
507: ,pay_assignment_actions aa
508: , pay_all_payrolls_f ppf
509: where pa.payroll_action_id = aa.payroll_action_id
510: and pa.effective_date = tp.regular_payment_date

Line 527: ,per_time_periods tp

523: ,fnd_date.date_to_displaydate(tp.start_date) COL02
524: ,tp.period_type COL07
525: ,ppf.payroll_name COL10
526: from pay_payroll_actions pa
527: ,per_time_periods tp
528: ,pay_assignment_actions aa
529: ,pay_all_payrolls_f ppf
530: where pa.payroll_action_id = aa.payroll_action_id
531: and pa.payroll_id = ppf.payroll_id