APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 2408: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2404: SELECT CUSTOMER_RECIPROCAL_FLAG, CREATED_BY_MODULE, APPLICATION_ID,
2405: RELATIONSHIP_TYPE, STATUS
2406: INTO l_customer_reciprocal_flag, l_created_by_module, l_application_id,
2407: l_relationship_type, l_status
2408: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2409: WHERE CUST_ACCT_RELATE_ID = p_cust_acct_relate_id;
2410: END IF;
2411:
2412: --------------------------------------

Line 2514: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489

2510: -- are primary key.
2511: IF p_create_update_flag = 'C' THEN
2512: BEGIN
2513: SELECT 'Y' INTO l_dummy
2514: FROM HZ_CUST_ACCT_RELATE_ALL -- Bug 3456489
2515: WHERE CUST_ACCOUNT_ID = p_cust_acct_relate_rec.cust_account_id
2516: AND RELATED_CUST_ACCOUNT_ID = p_cust_acct_relate_rec.related_cust_account_id
2517: --Bug 2985448
2518: AND STATUS='A'

Line 7761: * hz_cust_acct_relate_all table should be Y when validating

7757: * warehouse_id,date_type_preference,
7758: * ship_sets_include_lines_flag and arrivalsets_include_lines_flag
7759: * in procedure VALIDATE_CUST_SITE_USE.
7760: * 03-26-2002 P.Suresh Bug No : 2266165. Added the check that bill_to_flag of
7761: * hz_cust_acct_relate_all table should be Y when validating
7762: * bill_to_site_use_id.
7763: * 04-11-2002 P.Suresh Bug No : 2260832. Added the check for the status
7764: * when validating that only one primary is allowed for
7765: * one site use type per account in the procedure

Line 8361: FROM HZ_CUST_ACCT_RELATE_ALL

8357: SELECT l_cust_account_id
8358: FROM DUAL
8359: UNION
8360: SELECT CUST_ACCOUNT_ID
8361: FROM HZ_CUST_ACCT_RELATE_ALL
8362: WHERE RELATED_CUST_ACCOUNT_ID = l_cust_account_id
8363: AND BILL_TO_FLAG = 'Y' );
8364: EXCEPTION
8365: WHEN NO_DATA_FOUND THEN