APPS.GHR_MTI_INT dependencies on PER_PERSON_TYPES

Line 911: l_person_type_id per_person_types.person_type_id%type;

907:
908: l_proc_name varchar2(30) := 'mass_transfer_in';
909: l_proc varchar2(72) := g_package||l_proc_name;
910:
911: l_person_type_id per_person_types.person_type_id%type;
912: l_person_type_mti per_person_types.user_person_type%type;
913: l_person_type_mti_id per_person_types.person_type_id%type;
914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;

Line 912: l_person_type_mti per_person_types.user_person_type%type;

908: l_proc_name varchar2(30) := 'mass_transfer_in';
909: l_proc varchar2(72) := g_package||l_proc_name;
910:
911: l_person_type_id per_person_types.person_type_id%type;
912: l_person_type_mti per_person_types.user_person_type%type;
913: l_person_type_mti_id per_person_types.person_type_id%type;
914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;
916: l_person_row ghr_mt_people_f_v%rowtype;

Line 913: l_person_type_mti_id per_person_types.person_type_id%type;

909: l_proc varchar2(72) := g_package||l_proc_name;
910:
911: l_person_type_id per_person_types.person_type_id%type;
912: l_person_type_mti per_person_types.user_person_type%type;
913: l_person_type_mti_id per_person_types.person_type_id%type;
914: l_transfer_name ghr_mass_transfers.name%type;
915: l_effective_date ghr_mass_transfers.effective_date%type;
916: l_person_row ghr_mt_people_f_v%rowtype;
917: l_result varchar2(1);

Line 931: from per_person_types

927: e_transfer_in_warning exception;
928:
929: cursor cur_person_type is
930: select person_type_id
931: from per_person_types
932: where business_group_id = p_business_group_id
933: and user_person_type = 'Applicant';
934:
935: cursor cur_person_type_mti is

Line 939: per_person_types b

935: cursor cur_person_type_mti is
936: select b.USER_PERSON_TYPE usertype,
937: b.person_type_id person_type_id
938: from per_all_people_f a,
939: per_person_types b
940: where a.BUSINESS_GROUP_ID = b.BUSINESS_GROUP_ID
941: and a.business_group_id = p_business_group_id
942: and a.PERSON_TYPE_ID = b.PERSON_TYPE_ID
943: and a.person_id = l_person_row.mt_person_id