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.PER_SUC_BUS dependencies on PER_ASSIGNMENTS_F

Line 884: p_start_date per_assignments_f.effective_start_date%TYPE) IS

880: ------------------------------------------------------------------------
881:
882:
883: procedure chk_person_start_date( p_person_id per_people_f.person_id%TYPE,
884: p_start_date per_assignments_f.effective_start_date%TYPE) IS
885:
886: l_curr_position_id hr_positions.position_id%TYPE;
887:
888: CURSOR person_start_details (p_person_id per_people_f.person_id%TYPE,p_start_date per_assignments_f.effective_start_date%TYPE) IS

Line 888: CURSOR person_start_details (p_person_id per_people_f.person_id%TYPE,p_start_date per_assignments_f.effective_start_date%TYPE) IS

884: p_start_date per_assignments_f.effective_start_date%TYPE) IS
885:
886: l_curr_position_id hr_positions.position_id%TYPE;
887:
888: CURSOR person_start_details (p_person_id per_people_f.person_id%TYPE,p_start_date per_assignments_f.effective_start_date%TYPE) IS
889: SELECT paf.position_id
890: FROM per_assignments_f paf
891: WHERE paf.person_id=p_person_id
892: AND (SYSDATE BETWEEN paf.effective_start_date

Line 890: FROM per_assignments_f paf

886: l_curr_position_id hr_positions.position_id%TYPE;
887:
888: CURSOR person_start_details (p_person_id per_people_f.person_id%TYPE,p_start_date per_assignments_f.effective_start_date%TYPE) IS
889: SELECT paf.position_id
890: FROM per_assignments_f paf
891: WHERE paf.person_id=p_person_id
892: AND (SYSDATE BETWEEN paf.effective_start_date
893: AND NVL(paf.effective_end_date, SYSDATE))
894: AND paf.effective_start_date <= p_start_date;