APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 2382: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2378: SELECT CUSTOMER_RECIPROCAL_FLAG, CREATED_BY_MODULE, APPLICATION_ID,
2379: RELATIONSHIP_TYPE, STATUS
2380: INTO l_customer_reciprocal_flag, l_created_by_module, l_application_id,
2381: l_relationship_type, l_status
2382: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2383: WHERE CUST_ACCT_RELATE_ID = p_cust_acct_relate_id;
2384: END IF;
2385:
2386: --------------------------------------

Line 2488: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2484: -- are primary key.
2485: IF p_create_update_flag = 'C' THEN
2486: BEGIN
2487: SELECT 'Y' INTO l_dummy
2488: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2489: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
2490: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
2491: --Bug 2985448
2492: AND STATUS='A'

Line 7486: * hz_cust_acct_relate_all table should be Y when validating

7482: * warehouse_id,date_type_preference,
7483: * ship_sets_include_lines_flag and arrivalsets_include_lines_flag
7484: * in procedure VALIDATE_CUST_SITE_USE.
7485: * 03-26-2002 P.Suresh Bug No : 2266165. Added the check that bill_to_flag of
7486: * hz_cust_acct_relate_all table should be Y when validating
7487: * bill_to_site_use_id.
7488: * 04-11-2002 P.Suresh Bug No : 2260832. Added the check for the status
7489: * when validating that only one primary is allowed for
7490: * one site use type per account in the procedure

Line 8078: FROM HZ_CUST_ACCT_RELATE_ALL

8074: SELECT l_cust_account_id
8075: FROM DUAL
8076: UNION
8077: SELECT CUST_ACCOUNT_ID
8078: FROM HZ_CUST_ACCT_RELATE_ALL
8079: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id
8080: AND BILL_TO_FLAG = 'Y' );
8081: EXCEPTION
8082: WHEN NO_DATA_FOUND THEN