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

Line 2065: per_periods_of_service serv

2061: cursor csr_terminated_date is
2062: select serv.actual_termination_date actual_termination_date
2063: from
2064: per_all_assignments_f asg,
2065: per_periods_of_service serv
2066: where asg.assignment_id = p_person_rec.assignment_id
2067: and asg.period_of_service_id = serv.period_of_service_id
2068: and p_end_date between asg.effective_start_date and asg.effective_end_date
2069: and actual_termination_date <= g_effective_date

Line 2841: per_periods_of_service serv

2837: cursor csr_terminated_date is
2838: select serv.actual_termination_date actual_termination_date
2839: from
2840: per_all_assignments_f asg,
2841: per_periods_of_service serv
2842: where asg.assignment_id = p_person_rec.assignment_id
2843: and asg.period_of_service_id = serv.period_of_service_id
2844: and p_end_date between asg.effective_start_date and asg.effective_end_date
2845: and actual_termination_date <= g_effective_date

Line 3644: per_periods_of_service serv

3640: cursor csr_terminated_date is
3641: select serv.actual_termination_date actual_termination_date
3642: from
3643: per_all_assignments_f asg,
3644: per_periods_of_service serv
3645: where asg.assignment_id = l_asg_id
3646: and asg.period_of_service_id = serv.period_of_service_id
3647: and p_end_date between asg.effective_start_date and asg.effective_end_date
3648: and actual_termination_date <= g_effective_date

Line 4455: per_periods_of_service serv

4451: cursor csr_terminated_emp is
4452: select serv.actual_termination_date actual_termination_date
4453: from
4454: per_all_assignments_f asg,
4455: per_periods_of_service serv
4456: where asg.assignment_id = p_asg_id
4457: and serv.actual_termination_date is not null
4458: and asg.period_of_service_id = serv.period_of_service_id
4459: and p_payment_date between asg.effective_start_date and asg.effective_end_date

Line 9105: ,per_periods_of_service pos

9101: FROM pay_action_classifications class
9102: ,pay_payroll_actions pact
9103: ,pay_assignment_actions act
9104: ,per_all_assignments_f ass
9105: ,per_periods_of_service pos
9106: WHERE pos.person_id = p_person_id
9107: AND ass.period_of_service_id = pos.period_of_service_id
9108: AND act.assignment_id = ass.assignment_id
9109: AND act.action_sequence > p_action_sequence