APPS.IGS_FI_PRC_BALANCES dependencies on HZ_PARTIES

Line 79: CURSOR cur_person_number(cp_party_id IN hz_parties.party_id%TYPE) IS

75: g_ind_yes CONSTANT VARCHAR2(1) := 'Y';
76: l_validation_exp exception;
77:
78: -- Cursor for validating the person id
79: CURSOR cur_person_number(cp_party_id IN hz_parties.party_id%TYPE) IS
80: SELECT party_number
81: FROM hz_parties
82: WHERE party_id = cp_party_id;
83:

Line 81: FROM hz_parties

77:
78: -- Cursor for validating the person id
79: CURSOR cur_person_number(cp_party_id IN hz_parties.party_id%TYPE) IS
80: SELECT party_number
81: FROM hz_parties
82: WHERE party_id = cp_party_id;
83:
84: /* Removed the global variable uses to store the subaccount Name, as a part of Bug # 2564643 */
85:

Line 1342: l_person_number hz_parties.party_number%TYPE;

1338: l_message_name_1 fnd_new_messages.message_name%TYPE := NULL;
1339: l_msg_str_0 VARCHAR2(1000) := NULL;
1340: l_msg_str_1 VARCHAR2(1000) := NULL;
1341: l_rowid VARCHAR2(25);
1342: l_person_number hz_parties.party_number%TYPE;
1343: l_user_exception EXCEPTION;
1344: l_exception BOOLEAN;
1345:
1346: BEGIN