APPS.GHR_MTI_INT dependencies on PER_PERSON_TYPES

Line 914: l_person_type_id per_person_types.person_type_id%type;

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

Line 915: l_person_type_mti per_person_types.user_person_type%type;

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

Line 916: l_person_type_mti_id per_person_types.person_type_id%type;

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

Line 934: from per_person_types

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

Line 942: per_person_types b

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