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_FR_PTO_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 96: from per_periods_of_service pds

92: and p_date_earned between pee.effective_start_date and pee.effective_end_date;
93:
94: cursor csr_check_for_termination is
95: select null
96: from per_periods_of_service pds
97: ,PER_ALL_ASSIGNMENTS_F ASG
98: where pds.period_of_service_id = asg.period_of_service_id
99: and asg.assignment_id = p_assignment_id
100: and pds.actual_termination_date

Line 588: from per_periods_of_service pds

584: -- Includes this absence (if it is saved).
585: --
586: cursor csr_check_for_termination is
587: select null
588: from per_periods_of_service pds
589: ,PER_ALL_ASSIGNMENTS_F ASG
590: where pds.period_of_service_id = asg.period_of_service_id
591: and asg.assignment_id = p_assignment_id
592: and pds.actual_termination_date

Line 2262: per_periods_of_service ppos

2258: Cursor csr_assg_hiredate(c_assignment_id number,
2259: c_accrual_date date) is
2260: Select ppos.date_start
2261: From per_all_assignments_f pasg,
2262: per_periods_of_service ppos
2263: Where ppos.period_of_service_id = pasg.period_of_service_id
2264: and pasg.assignment_id = c_assignment_id
2265: and c_accrual_date between pasg.effective_start_date
2266: and pasg.effective_end_date;

Line 6014: From per_periods_of_service ppos

6010: --
6011: -- Defining cursor selecting hiredate
6012: Cursor csr_assg_hiredate(c_person_id number) is
6013: Select max(ppos.date_start)
6014: From per_periods_of_service ppos
6015: Where ppos.person_id = c_person_id
6016: and ppos.date_start <= p_abs_date_start;
6017:
6018: --