APPS.IGS_AD_IMP_004 dependencies on IGS_PE_PERSON_TYPES

Line 858: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

854:
855: l_rowid VARCHAR2(25);
856: l_org_id NUMBER(15);
857: l_type_instance_id NUMBER;
858: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
859: CURSOR
860: c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
861: SELECT
862: person_type_code

Line 860: c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS

856: l_org_id NUMBER(15);
857: l_type_instance_id NUMBER;
858: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
859: CURSOR
860: c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
861: SELECT
862: person_type_code
863: FROM
864: igs_pe_person_types

Line 864: igs_pe_person_types

860: c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE) IS
861: SELECT
862: person_type_code
863: FROM
864: igs_pe_person_types
865: WHERE
866: system_type=l_system_type;
867: BEGIN --Begin Local Loop 1
868: l_org_id := igs_ge_gen_003.get_org_id;