APPS.PQH_SS_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 23: from per_all_people_f

19: l_bus_grp number;
20: --
21: cursor c_bus_grp_id(p_person_id number) is
22: select business_group_id
23: from per_all_people_f
24: where person_id = p_person_id;
25: --
26: cursor c_run(p_person_id number, p_rptg_grp_id number,
27: p_business_group_id number) is

Line 552: FROM per_all_people_f

548: ,p_effectiveDate IN DATE ) RETURN NUMBER IS
549: --
550: CURSOR cur_bg(p_effectiveDate IN DATE) IS
551: SELECT business_group_id
552: FROM per_all_people_f
553: WHERE person_id = p_personId
554: AND p_effectiveDate BETWEEN effective_start_date AND effective_end_date ;
555: --
556: l_businessGrpId NUMBER;