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_SERVICE

Line 527: from per_periods_of_service pos

523: and asg.assignment_id = p_assignment_id;
524: --
525: cursor term_date_csr is
526: select pos.actual_termination_date
527: from per_periods_of_service pos
528: ,per_all_assignments_f asg
529: where asg.period_of_service_id = pos.period_of_service_id
530: and p_period_start_date-1 between asg.effective_start_date
531: and asg.effective_end_date

Line 705: from per_periods_of_service pos

701: p_assignment_id NUMBER,
702: p_report_date DATE)
703: is
704: select 'Y'
705: from per_periods_of_service pos
706: where pos.date_start between add_months(p_report_date,-1) and p_report_date
707: and pos.period_of_service_id in (
708: select paf.period_of_service_id
709: from per_all_assignments_f paf

Line 758: from per_periods_of_service pos

754: p_cur_date_from DATE,
755: p_cur_date_to DATE)
756: is
757: select 'Y'
758: from per_periods_of_service pos
759: where pos.date_start between p_cur_date_from and p_cur_date_to
760: and pos.period_of_service_id in (
761: select paf.period_of_service_id
762: from per_all_assignments_f paf