APPS.OE_ORDER_PURGE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 289: FROM HZ_CUST_ACCOUNTS c,

285: THEN
286: l_sql_stmt := l_sql_stmt || ' AND OOH.SOLD_TO_ORG_ID = :p5';
287: SELECT p.PARTY_NAME
288: INTO l_customer_name
289: FROM HZ_CUST_ACCOUNTS c,
290: HZ_PARTIES p
291: WHERE c.CUST_ACCOUNT_ID = p_customer_id
292: AND c.PARTY_ID = p.PARTY_ID;
293:

Line 767: FROM HZ_CUST_ACCOUNTS c,

763: IF nvl(p_customer_id,0) <> 0 THEN
764:
765: SELECT p.PARTY_NAME
766: INTO l_customer_name
767: FROM HZ_CUST_ACCOUNTS c,
768: HZ_PARTIES p
769: WHERE c.CUST_ACCOUNT_ID = p_customer_id
770: AND c.PARTY_ID = p.PARTY_ID;
771: