APPS.IGS_AD_SS_PERSON_PKG dependencies on HZ_PERSON_PROFILES

Line 581: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;

577: WHERE p.party_id = x_person_id;
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

Line 871: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;

867: Who When What
868: (reverse chronological order - newest change first)
869: mmkumar 19-JUL-2005 Passed NULL for x_oss_org_unit_cd in add_row
870: ***************************************************************/
871: x_profile_id HZ_PERSON_PROFILES.PERSON_PROFILE_ID%TYPE;
872: lv_rowid VARCHAR2(25);
873:
874: CURSOR c1 IS
875: SELECT P_ID.ROWID,P_ID.*