APPS.PA_CI_MERGE_PKG dependencies on HZ_PARTIES

Line 136: l_party_type hz_parties.party_type%TYPE;

132: p_batch_party_id IN NUMBER,
133: x_return_status OUT NOCOPY VARCHAR2)
134: IS
135: l_dummy NUMBER;
136: l_party_type hz_parties.party_type%TYPE;
137:
138: CURSOR c_parties IS
139: SELECT project_party_id,
140: object_id,

Line 176: FROM hz_parties

172: EXCEPTION
173: WHEN NO_DATA_FOUND THEN
174: SELECT party_type
175: INTO l_party_type
176: FROM hz_parties
177: WHERE party_id = p_to_fk_id;
178:
179: IF l_party_type = 'ORGANIZATION' THEN
180: FOR cp_party IN c_parties LOOP