APPS.OE_VALIDATE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 4117: FROM HZ_CUST_ACCOUNT_ROLES

4113: END IF;
4114:
4115: SELECT 'VALID'
4116: INTO l_dummy
4117: FROM HZ_CUST_ACCOUNT_ROLES
4118: WHERE CUST_ACCOUNT_ROLE_ID = p_sold_to_contact_id
4119: AND ROLE_TYPE = 'CONTACT'
4120: AND STATUS = 'A';
4121:

Line 4180: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

4176: l_resp_type := 'SHIP_TO';
4177:
4178: SELECT 'VALID'
4179: INTO l_dummy
4180: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4181: , HZ_ROLE_RESPONSIBILITY ROL
4182: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_ship_to_contact_id
4183: AND ACCT_ROLE.STATUS = 'A'
4184: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 4248: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

4244: l_resp_type := 'SHIP_TO';
4245:
4246: SELECT 'VALID'
4247: INTO l_dummy
4248: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4249: , HZ_ROLE_RESPONSIBILITY ROL
4250: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_intermed_ship_to_contact_id
4251: AND ACCT_ROLE.STATUS = 'A'
4252: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 4317: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

4313: l_resp_type := 'BILL_TO';
4314:
4315: SELECT 'VALID'
4316: INTO l_dummy
4317: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4318: , HZ_ROLE_RESPONSIBILITY ROL
4319: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_invoice_to_contact_id
4320: AND ACCT_ROLE.STATUS = 'A'
4321: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 4379: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

4375: END IF;
4376:
4377: SELECT 'VALID'
4378: INTO l_dummy
4379: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4380: , HZ_ROLE_RESPONSIBILITY ROL
4381: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_deliver_to_contact_id
4382: AND ACCT_ROLE.STATUS = 'A'
4383: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 22171: FROM HZ_CUST_ACCOUNT_ROLES

22167: END IF;
22168:
22169: SELECT 'VALID'
22170: INTO l_dummy
22171: FROM HZ_CUST_ACCOUNT_ROLES
22172: WHERE CUST_ACCOUNT_ROLE_ID = p_end_customer_contact_id
22173: AND ROLE_TYPE = 'CONTACT'
22174: AND STATUS = 'A';
22175: