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 575: from per_periods_of_service pps

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

Line 1021: from per_periods_of_service service,

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

Line 1049: FROM per_periods_of_service

1045: l_date_start date;
1046:
1047: CURSOR cur_max_date_start IS
1048: SELECT max(date_start)
1049: FROM per_periods_of_service
1050: WHERE person_id = p_person_id
1051: AND business_group_id = p_business_group_id
1052: AND date_start <= p_effective_date;
1053: --AND date_start >= p_effective_date - 400;

Line 1891: from per_periods_of_service service,

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