225: l_impact_name VARCHAR2(80);
226:
227: CURSOR get_internal_party_id
228: IS 229: select hp.party_id from fnd_user fu, 230: hz_parties hp
231: where
232: user_id = FND_GLOBAL.user_id
233: and employee_id is not null
Line 239: select hp.party_id from fnd_user fu,
235:
236:
237: CURSOR get_external_party_id
238: IS 239: select hp.party_id from fnd_user fu, 240: hz_parties hp
241: where
242: user_id = FND_GLOBAL.user_id
243: and employee_id is null