APPS.PER_IN_PERSON_LEG_HOOK dependencies on HR_LOOKUPS

Line 273: TYPE t_pt_tbl IS TABLE OF HR_LOOKUPS.LOOKUP_CODE%TYPE index by binary_integer;

269: --------------------------------------------------------------------------
270: FUNCTION chk_person_type (p_code in VARCHAR2)
271: RETURN BOOLEAN
272: IS
273: TYPE t_pt_tbl IS TABLE OF HR_LOOKUPS.LOOKUP_CODE%TYPE index by binary_integer;
274: l_person_type t_pt_tbl;
275: l_loop_count NUMBER ;
276: l_procedure VARCHAR2(100);
277: l_message VARCHAR2(250);

Line 751: l_value hr_lookups.meaning%TYPE;

747: AND p_effective_date BETWEEN pptu.effective_start_date
748: AND pptu.effective_end_date;
749:
750: l_person_type per_person_types.system_person_type%TYPE;
751: l_value hr_lookups.meaning%TYPE;
752: l_pan_af hr_lookups.lookup_code%TYPE;
753: l_military_status hr_lookups.lookup_code%TYPE;
754: l_resident_status hr_lookups.lookup_code%TYPE;
755: l_procedure VARCHAR2(100);

Line 752: l_pan_af hr_lookups.lookup_code%TYPE;

748: AND pptu.effective_end_date;
749:
750: l_person_type per_person_types.system_person_type%TYPE;
751: l_value hr_lookups.meaning%TYPE;
752: l_pan_af hr_lookups.lookup_code%TYPE;
753: l_military_status hr_lookups.lookup_code%TYPE;
754: l_resident_status hr_lookups.lookup_code%TYPE;
755: l_procedure VARCHAR2(100);
756: l_message VARCHAR2(250);

Line 753: l_military_status hr_lookups.lookup_code%TYPE;

749:
750: l_person_type per_person_types.system_person_type%TYPE;
751: l_value hr_lookups.meaning%TYPE;
752: l_pan_af hr_lookups.lookup_code%TYPE;
753: l_military_status hr_lookups.lookup_code%TYPE;
754: l_resident_status hr_lookups.lookup_code%TYPE;
755: l_procedure VARCHAR2(100);
756: l_message VARCHAR2(250);
757:

Line 754: l_resident_status hr_lookups.lookup_code%TYPE;

750: l_person_type per_person_types.system_person_type%TYPE;
751: l_value hr_lookups.meaning%TYPE;
752: l_pan_af hr_lookups.lookup_code%TYPE;
753: l_military_status hr_lookups.lookup_code%TYPE;
754: l_resident_status hr_lookups.lookup_code%TYPE;
755: l_procedure VARCHAR2(100);
756: l_message VARCHAR2(250);
757:
758: