eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ES_ONLINE_SOE dependencies on PER_TIME_PERIODS

Line 417: , per_time_periods tp

413: --
414: cursor periodDates IS
415: SELECT action_type
416: FROM pay_payroll_actions pa
417: , per_time_periods tp
418: , pay_assignment_actions aa
419: WHERE pa.payroll_action_id = aa.payroll_action_id
420: AND pa.effective_date = tp.regular_payment_date
421: AND pa.payroll_id = tp.payroll_id

Line 445: ,per_time_periods tp1

441: ,ppf.payroll_name COL10
442: ,prtt.RUN_TYPE_NAME COL08
443: from pay_payroll_actions pa1
444: ,pay_payroll_actions pa2
445: ,per_time_periods tp1
446: ,per_time_periods tp2
447: ,pay_assignment_actions aa1
448: ,pay_assignment_actions aa2
449: ,pay_all_payrolls_f ppf

Line 446: ,per_time_periods tp2

442: ,prtt.RUN_TYPE_NAME COL08
443: from pay_payroll_actions pa1
444: ,pay_payroll_actions pa2
445: ,per_time_periods tp1
446: ,per_time_periods tp2
447: ,pay_assignment_actions aa1
448: ,pay_assignment_actions aa2
449: ,pay_all_payrolls_f ppf
450: ,pay_run_types_f prtf

Line 477: ,per_time_periods tp

473: ,tp.period_type COL07
474: ,ppf.payroll_name COL10
475: ,prtt.RUN_TYPE_NAME COL08
476: from pay_payroll_actions pa
477: ,per_time_periods tp
478: ,pay_assignment_actions aa
479: , pay_all_payrolls_f ppf
480: ,pay_run_types_f prtf
481: ,pay_run_types_f_tl prtt

Line 504: ,per_time_periods tp

500: ,tp.period_type COL07
501: ,ppf.payroll_name COL10
502: ,prtt.RUN_TYPE_NAME COL08
503: FROM pay_payroll_actions pa
504: ,per_time_periods tp
505: ,pay_assignment_actions aa
506: ,pay_all_payrolls_f ppf
507: ,pay_run_types_f prtf
508: ,pay_run_types_f_tl prtt