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 4743: FROM hz_parties party, hz_cust_accounts cust_acct

4739: , (SELECT cust_account_id customer_id
4740: , party.party_name customer_name
4741: , party.party_number customer_number
4742: , price_list_id
4743: FROM hz_parties party, hz_cust_accounts cust_acct
4744: WHERE cust_acct.party_id = party.party_id) rc
4745: WHERE mip.sell_organization_id = p_to_org_id
4746: AND mip.ship_organization_id = p_from_org_id
4747: AND mip.flow_type = l_flow_type