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 773: l_value hr_lookups.meaning%TYPE;

769: AND p_effective_date BETWEEN pptu.effective_start_date
770: AND pptu.effective_end_date;
771:
772: l_person_type per_person_types.system_person_type%TYPE;
773: l_value hr_lookups.meaning%TYPE;
774: l_pan_af hr_lookups.lookup_code%TYPE;
775: l_military_status hr_lookups.lookup_code%TYPE;
776: l_resident_status hr_lookups.lookup_code%TYPE;
777: l_procedure VARCHAR2(100);

Line 774: l_pan_af hr_lookups.lookup_code%TYPE;

770: AND pptu.effective_end_date;
771:
772: l_person_type per_person_types.system_person_type%TYPE;
773: l_value hr_lookups.meaning%TYPE;
774: l_pan_af hr_lookups.lookup_code%TYPE;
775: l_military_status hr_lookups.lookup_code%TYPE;
776: l_resident_status hr_lookups.lookup_code%TYPE;
777: l_procedure VARCHAR2(100);
778: l_message VARCHAR2(250);

Line 775: l_military_status hr_lookups.lookup_code%TYPE;

771:
772: l_person_type per_person_types.system_person_type%TYPE;
773: l_value hr_lookups.meaning%TYPE;
774: l_pan_af hr_lookups.lookup_code%TYPE;
775: l_military_status hr_lookups.lookup_code%TYPE;
776: l_resident_status hr_lookups.lookup_code%TYPE;
777: l_procedure VARCHAR2(100);
778: l_message VARCHAR2(250);
779:

Line 776: l_resident_status hr_lookups.lookup_code%TYPE;

772: l_person_type per_person_types.system_person_type%TYPE;
773: l_value hr_lookups.meaning%TYPE;
774: l_pan_af hr_lookups.lookup_code%TYPE;
775: l_military_status hr_lookups.lookup_code%TYPE;
776: l_resident_status hr_lookups.lookup_code%TYPE;
777: l_procedure VARCHAR2(100);
778: l_message VARCHAR2(250);
779:
780: