358:
359:
360: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS
361: SELECT p.party_id, p.object_id
362: FROM JTF_PARTIES_V p, jtf_party_relationships_v rel
363: WHERE p.party_number = x_contactNum ;
364:
365: BEGIN
366: OPEN C_getDtlsFromConNum (l_contactNumber);
373: PROCEDURE GetDtlsFromCustNum IS
374:
375: CURSOR C_GetCustId(x_custnum VARCHAR2) IS
376: SELECT party_id
377: FROM jtf_parties_v
378: WHERE party_number = x_custnum;
379:
380:
381: BEGIN