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.HR_PERSON_RECORD dependencies on PER_PERIODS_OF_PLACEMENT

Line 1528: from per_periods_of_placement ppp

1524: ,to_char(ppp.actual_termination_date,'YYYY-MM-DD') actual_termination_date
1525: ,to_char(ppp.final_process_date,'YYYY-MM-DD') final_process_date
1526: ,to_char(ppp.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
1527: ,termination_reason leaving_reason
1528: from per_periods_of_placement ppp
1529: where ppp.person_id = p_person_id
1530: and (ppp.date_start = (
1531: select max(ppp1.date_start)
1532: from per_periods_of_placement ppp1

Line 1532: from per_periods_of_placement ppp1

1528: from per_periods_of_placement ppp
1529: where ppp.person_id = p_person_id
1530: and (ppp.date_start = (
1531: select max(ppp1.date_start)
1532: from per_periods_of_placement ppp1
1533: where ppp1.person_id = p_person_id
1534: and ppp1.date_start <= to_date(p_effective_end_date,'YYYY-MM-DD') ) );
1535:
1536: