APPS.OE_ORDER_PURGE_PVT dependencies on HZ_PARTIES

Line 290: HZ_PARTIES p

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:
294: IF l_where_condition IS NULL

Line 768: HZ_PARTIES p

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:
772: l_sql_stmt := l_sql_stmt || ' AND OOH.SOLD_TO_ORG_ID = :p4';