APPS.IGS_EN_ADD_UNITS_API dependencies on HZ_PARTIES

Line 958: FROM HZ_PARTIES

954:
955: -- cursor to get the person number
956: CURSOR c_get_per_num IS
957: SELECT party_number
958: FROM HZ_PARTIES
959: WHERE party_id = p_person_id;
960:
961: -- cursor to get the rowid of the plannig units table
962: CURSOR c_get_rowid IS

Line 971: l_person_number hz_parties.party_number%TYPE;

967: AND uoo_id = p_uoo_id
968: AND cart_error_flag = 'Y';
969:
970: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
971: l_person_number hz_parties.party_number%TYPE;
972: l_rowid VARCHAR2(30);
973: l_enc_message_name VARCHAR2(2000);
974: l_app_short_name VARCHAR2(100);
975: l_msg_index NUMBER;

Line 1116: FROM HZ_PARTIES

1112:
1113: -- cursor to get the person number
1114: CURSOR c_get_per_num IS
1115: SELECT party_number
1116: FROM HZ_PARTIES
1117: WHERE party_id = p_person_id;
1118:
1119: -- cursor to get the rowid from the plaannig units table
1120: CURSOR c_get_rowid IS

Line 1129: l_person_number hz_parties.party_number%TYPE;

1125: AND uoo_id = p_uoo_id
1126: AND cart_error_flag = 'Y';
1127:
1128: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
1129: l_person_number hz_parties.party_number%TYPE;
1130: l_rowid VARCHAR2(30);
1131: l_enc_message_name VARCHAR2(2000);
1132: l_app_short_name VARCHAR2(100);
1133: l_msg_index NUMBER;

Line 1814: FROM HZ_PARTIES

1810:
1811: -- cursor to get the person number
1812: CURSOR c_get_per_num IS
1813: SELECT party_number
1814: FROM HZ_PARTIES
1815: WHERE party_id = p_person_id;
1816:
1817: l_person_number HZ_PARTIES.party_number%TYPE;
1818:

Line 1817: l_person_number HZ_PARTIES.party_number%TYPE;

1813: SELECT party_number
1814: FROM HZ_PARTIES
1815: WHERE party_id = p_person_id;
1816:
1817: l_person_number HZ_PARTIES.party_number%TYPE;
1818:
1819: -- cursor to fetch the superior units
1820: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
1821: SELECT sup_uoo_id