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 1241: p_start_date per_assignments_f.effective_start_date%TYPE

1237: --
1238: ------------------------------------------------------------------------
1239: PROCEDURE chk_person_start_date (
1240: p_person_id per_people_f.person_id%TYPE,
1241: p_start_date per_assignments_f.effective_start_date%TYPE
1242: )
1243: IS
1244: l_curr_position_id hr_positions.position_id%TYPE;
1245:

Line 1248: p_start_date per_assignments_f.effective_start_date%TYPE

1244: l_curr_position_id hr_positions.position_id%TYPE;
1245:
1246: CURSOR person_start_details (
1247: p_person_id per_people_f.person_id%TYPE,
1248: p_start_date per_assignments_f.effective_start_date%TYPE
1249: )
1250: IS
1251: SELECT paf.position_id
1252: FROM per_assignments_f paf

Line 1252: FROM per_assignments_f paf

1248: p_start_date per_assignments_f.effective_start_date%TYPE
1249: )
1250: IS
1251: SELECT paf.position_id
1252: FROM per_assignments_f paf
1253: WHERE paf.person_id = p_person_id
1254: AND (SYSDATE BETWEEN paf.effective_start_date AND NVL (paf.effective_end_date, SYSDATE)
1255: )
1256: AND paf.effective_start_date <= p_start_date;