APPS.PON_OPEN_INTERFACE_PVT dependencies on HZ_PARTIES

Line 1712: FROM HZ_PARTIES

1708: SELECT PERSON_LAST_NAME
1709: ||','
1710: ||PERSON_FIRST_NAME
1711: INTO L_TRADING_PARTNER_CONTACT_NAME
1712: FROM HZ_PARTIES
1713: WHERE PARTY_ID=L_TRADING_PARTNER_CONTACT_ID;
1714: END IF;
1715:
1716: -- check if the Supplier has been invited multiple times for the same Supplier Site or without a Supplier Site selection

Line 2010: AND NOT EXISTS(SELECT 1 FROM hz_parties

2006: SYSDATE,
2007: l_cp_login_id)
2008:
2009: WHEN (sel_tpc_id IS NOT NULL
2010: AND NOT EXISTS(SELECT 1 FROM hz_parties
2011: WHERE party_id=sel_tpc_id))
2012: THEN INTO PON_INTERFACE_ERRORS
2013: (
2014: INTERFACE_TYPE ,