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_FLEX_LOGIC dependencies on PER_PERIODS_OF_PLACEMENT

Line 536: from per_periods_of_placement pps

532: and asg.assignment_id = p_assignment_id;
533: --
534: cursor cwk_term_date_csr is
535: select pps.actual_termination_date
536: from per_periods_of_placement pps
537: ,per_all_assignments_f asg
538: where asg.person_id = pps.person_id
539: and asg.period_of_placement_date_start = pps.date_start
540: and p_period_start_date-1 between asg.effective_start_date

Line 774: from per_periods_of_placement pps

770: p_cur_date_from DATE,
771: p_cur_date_to DATE)
772: is
773: select 'Y'
774: from per_periods_of_placement pps
775: where pps.date_start between p_cur_date_from and p_cur_date_to
776: and exists (select 1
777: from per_all_assignments_f paf
778: where paf.person_id = pps.person_id