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;

Line 824: select ppt.SYSTEM_PERSON_TYPE from per_all_people_f paf, per_person_types ppt where person_id = l_person_id

820: FROM hr_api_transactions
821: WHERE transaction_id = c_txnId;
822: --
823: CURSOR chk_ex_emp(l_person_id in number, l_effective_date in Date) is
824: select ppt.SYSTEM_PERSON_TYPE from per_all_people_f paf, per_person_types ppt where person_id = l_person_id
825: and paf.PERSON_TYPE_ID = ppt.PERSON_TYPE_ID
826: and l_effective_date between effective_start_date and effective_end_date;
827: --
828: l_ovn VARCHAR2(15);