APPS.IGS_AD_SS_PERSON_PKG dependencies on IGS_PE_PERSON

Line 582: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

578: lv_rowid VARCHAR2(30);
579: lv_rowid1 VARCHAR2(30);
580: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
581: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
582: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
583: CURSOR c_pe_rowid (cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE,
584: cp_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE) IS
585: SELECT rowid
586: FROM HZ_PARTIES

Line 583: CURSOR c_pe_rowid (cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE,

579: lv_rowid1 VARCHAR2(30);
580: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
581: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
582: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
583: CURSOR c_pe_rowid (cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE,
584: cp_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE) IS
585: SELECT rowid
586: FROM HZ_PARTIES
587: WHERE party_id = cp_person_id

Line 584: cp_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE) IS

580: ln_type_instance_id IGS_PE_TYP_INSTANCES.TYPE_INSTANCE_ID%TYPE;
581: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
582: lv_Person_Type_Code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
583: CURSOR c_pe_rowid (cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE,
584: cp_person_number IGS_PE_PERSON.PERSON_NUMBER%TYPE) IS
585: SELECT rowid
586: FROM HZ_PARTIES
587: WHERE party_id = cp_person_id
588: AND party_number = cp_person_number;

Line 591: FROM igs_pe_person_types pt

587: WHERE party_id = cp_person_id
588: AND party_number = cp_person_number;
589: CURSOR ptc IS
590: SELECT pt.person_type_code
591: FROM igs_pe_person_types pt
592: WHERE pt.system_type = 'OTHER';
593:
594: tmp_var1 VARCHAR2(2000);
595: tmp_var VARCHAR2(2000);