APPS.INV_TRANSACTION_FLOW_PUB dependencies on HZ_CUST_ACCOUNTS

Line 2371: FROM HZ_CUST_ACCOUNTS

2367: BEGIN
2368: SELECT 'Y' INTO l_valid FROM dual
2369: WHERE
2370: exists(SELECT CUST_ACCOUNT_ID
2371: FROM HZ_CUST_ACCOUNTS
2372: WHERE CUST_ACCOUNT_ID = p_customer_id);
2373: EXCEPTION
2374: WHEN no_data_found THEN
2375: l_valid := 'N';

Line 4574: FROM hz_parties party, hz_cust_accounts cust_acct

4570: , (SELECT cust_account_id customer_id
4571: , party.party_name customer_name
4572: , party.party_number customer_number
4573: , price_list_id
4574: FROM hz_parties party, hz_cust_accounts cust_acct
4575: WHERE cust_acct.party_id = party.party_id) rc
4576: WHERE mip.sell_organization_id = p_to_org_id
4577: AND mip.ship_organization_id = p_from_org_id
4578: AND mip.flow_type = l_flow_type