DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_PKG dependencies on IGS_PE_PERSON_TYPES

Line 600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

596: lv_rowid VARCHAR2(30);
597: lv_rowid1 VARCHAR2(30);
598: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
599: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
600: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
601:
602: CURSOR c_pe_rowid (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
603: SELECT ROWID
604: FROM HZ_PARTIES

Line 612: FROM igs_pe_person_types pt

608:
609:
610: CURSOR ptc IS
611: SELECT pt.person_type_code
612: FROM igs_pe_person_types pt
613: WHERE pt.system_type = 'OTHER'
614: AND pt.closed_ind = 'N';
615:
616: