APPS.PER_SUC_BUS dependencies on PER_PEOPLE_F

Line 112: FROM per_people_f ppf,

108: l_dummy varchar2(1);
109: --
110: cursor c1 is
111: SELECT NULL
112: FROM per_people_f ppf,
113: per_person_type_usages_f ptu,
114: per_person_types ppt
115: WHERE ppf.person_id = p_person_id
116: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 883: procedure chk_person_start_date( p_person_id per_people_f.person_id%TYPE,

879: --
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:

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