APPS.ASO_VALIDATE_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2204: SELECT begin_date, end_date FROM HZ_CUST_ACCOUNT_ROLES

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