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

Line 1555: per_periods_of_service serv

1551: cursor csr_terminated_date is
1552: select serv.actual_termination_date actual_termination_date
1553: from
1554: per_all_assignments_f asg,
1555: per_periods_of_service serv
1556: where asg.assignment_id = p_person_rec.assignment_id
1557: and asg.period_of_service_id = serv.period_of_service_id
1558: and p_end_date between asg.effective_start_date and asg.effective_end_date
1559: and actual_termination_date <= g_effective_date

Line 2363: per_periods_of_service serv

2359: cursor csr_terminated_date is
2360: select serv.actual_termination_date actual_termination_date
2361: from
2362: per_all_assignments_f asg,
2363: per_periods_of_service serv
2364: where asg.assignment_id = p_person_rec.assignment_id
2365: and asg.period_of_service_id = serv.period_of_service_id
2366: and p_end_date between asg.effective_start_date and asg.effective_end_date
2367: and actual_termination_date <= g_effective_date

Line 3177: per_periods_of_service serv

3173: cursor csr_terminated_date is
3174: select serv.actual_termination_date actual_termination_date
3175: from
3176: per_all_assignments_f asg,
3177: per_periods_of_service serv
3178: where asg.assignment_id = l_asg_id
3179: and asg.period_of_service_id = serv.period_of_service_id
3180: and p_end_date between asg.effective_start_date and asg.effective_end_date
3181: and actual_termination_date <= g_effective_date

Line 3880: per_periods_of_service serv

3876: cursor csr_terminated_emp is
3877: select serv.actual_termination_date actual_termination_date
3878: from
3879: per_all_assignments_f asg,
3880: per_periods_of_service serv
3881: where asg.assignment_id = p_asg_id
3882: and serv.actual_termination_date is not null
3883: and asg.period_of_service_id = serv.period_of_service_id
3884: and p_payment_date between asg.effective_start_date and asg.effective_end_date;

Line 8471: ,per_periods_of_service pos

8467: FROM pay_action_classifications class
8468: ,pay_payroll_actions pact
8469: ,pay_assignment_actions act
8470: ,per_all_assignments_f ass
8471: ,per_periods_of_service pos
8472: WHERE pos.person_id = p_person_id
8473: AND ass.period_of_service_id = pos.period_of_service_id
8474: AND act.assignment_id = ass.assignment_id
8475: AND act.action_sequence > p_action_sequence