APPS.PER_SUC_BUS dependencies on PER_PEOPLE_F

Line 130: FROM per_people_f ppf, per_person_type_usages_f ptu, per_person_types ppt

126: --
127: CURSOR c1
128: IS
129: SELECT NULL
130: FROM per_people_f ppf, per_person_type_usages_f ptu, per_person_types ppt
131: WHERE ppf.person_id = p_person_id
132: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
133: AND ppf.person_id = ptu.person_id
134: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date

Line 1240: p_person_id per_people_f.person_id%TYPE,

1236: -- Internal and External use.
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;

Line 1247: p_person_id per_people_f.person_id%TYPE,

1243: IS
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