APPS.IGS_PE_PERSON_PKG dependencies on HZ_PERSON_PROFILES

Line 599: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;

595:
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

Line 917: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;

913: vrathi 2003/07/11 Bug No:3045079 The sysdate should be truncated before inserting into
914: IGS_PE_ALT_PERS_ID to eliminate the time component
915: (reverse chronological order - newest change first)
916: ***************************************************************/
917: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
918:
919: lv_rowid VARCHAR2(25);
920:
921: CURSOR c1 IS