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

Line 571: from per_periods_of_service pps

567: NULL recall_date,
568: pps.pds_information1 roe_reason,
569: pps.pds_information2 roe_comment,
570: pps.date_start
571: from per_periods_of_service pps
572: where pps.person_id=p_person_id
573: and pps.business_group_id = p_business_group_id
574: and p_effective_date - nvl(pps.actual_termination_date,p_effective_date) <= 31
575: and pps.date_start <= p_effective_date

Line 1017: from per_periods_of_service service,

1013: multiple_gre boolean := FALSE;
1014:
1015: cursor cur_employee_hire_date is
1016: select max(service.date_start) hire_date
1017: from per_periods_of_service service,
1018: per_assignments_f asg
1019: -- where asg.assignment_id = l_assignment_id
1020: where asg.person_id = l_person_id
1021: and l_effective_date BETWEEN

Line 1045: FROM per_periods_of_service

1041: l_date_start date;
1042:
1043: CURSOR cur_max_date_start IS
1044: SELECT max(date_start)
1045: FROM per_periods_of_service
1046: WHERE person_id = p_person_id
1047: AND business_group_id = p_business_group_id
1048: AND date_start <= p_effective_date;
1049: --AND date_start >= p_effective_date - 400;

Line 1887: from per_periods_of_service service,

1883: AND nvl(ADDR.date_to,l_effective_date);
1884:
1885: cursor cur_employee_hire_date is
1886: select max(service.date_start) hire_date
1887: from per_periods_of_service service,
1888: per_assignments_f asg
1889: where asg.assignment_id = l_assignment_id
1890: and l_effective_date BETWEEN
1891: asg.effective_start_date