APPS.PQH_SS_UTILITY dependencies on PER_PERSON_TYPES
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);