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.PEPTOEXC dependencies on PER_PERIODS_OF_SERVICE

Line 182: from per_periods_of_service pps,

178: 12 + trunc(months_between(bact.effective_date,
179: pps.date_start
180: )/12) *12) finyear
181: into l_accrual_year_end
182: from per_periods_of_service pps,
183: per_all_assignments_f asg,
184: pay_payroll_actions bact,
185: pay_assignment_actions bal_assact
186: where bact.payroll_action_id = p_owner_payroll_action_id

Line 229: from per_periods_of_service pps,

225: 12 + trunc(months_between(bact.effective_date,
226: pps.date_start
227: )/12) *12) finyear
228: into l_accrual_year_end
229: from per_periods_of_service pps,
230: per_all_assignments_f asg,
231: pay_payroll_actions bact,
232: pay_assignment_actions bal_assact
233: where bact.payroll_action_id = p_owner_payroll_action_id

Line 526: from per_periods_of_service pps,

522: 12 + trunc(months_between(bact.date_earned,
523: pps.date_start
524: )/12) *12) finyear
525: into l_expiry_date
526: from per_periods_of_service pps,
527: per_all_assignments_f asg,
528: pay_payroll_actions bact,
529: pay_assignment_actions bal_assact
530: where bact.payroll_action_id = p_owner_payroll_action_id

Line 592: from per_periods_of_service pps,

588: 12 + trunc(months_between(bact.date_earned,
589: pps.date_start
590: )/12) *12) finyear
591: into l_expiry_date
592: from per_periods_of_service pps,
593: per_all_assignments_f asg,
594: pay_payroll_actions bact,
595: pay_assignment_actions bal_assact
596: where bact.payroll_action_id = p_owner_payroll_action_id