APPS.ASO_VALIDATE_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2206: SELECT begin_date, end_date FROM HZ_CUST_ACCOUNT_ROLES

2202: SELECT a.status FROM HZ_CUST_ACCOUNTS a
2203: WHERE a.party_id = p_cust_party_id AND cust_account_id = p_cust_account_id;
2204:
2205: CURSOR C_Account_Role IS
2206: SELECT begin_date, end_date FROM HZ_CUST_ACCOUNT_ROLES
2207: WHERE party_id = p_party_id AND cust_account_id = p_cust_account_id
2208: AND role_type ='ACCOUNT_USER';
2209:
2210: CURSOR C_party(l_pty_id NUMBER) IS