DBA Data[Home] [Help]

APPS.IEX_UWQ_SEL_PKG dependencies on JTF_PARTIES_V

Line 362: FROM JTF_PARTIES_V p, jtf_party_relationships_v rel

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);

Line 377: FROM jtf_parties_v

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