DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 4339: Hz_cust_account_roles acct_roles

4335:
4336: CURSOR l_valid_contact_csr IS
4337: SELECT 'X'
4338: FROM gms_awards_all ga,
4339: Hz_cust_account_roles acct_roles
4340: WHERE ga.award_id = G_contact_rec.award_id
4341: AND decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)=acct_roles.cust_account_id
4342: AND acct_roles.cust_account_role_id = G_contact_rec.contact_id;
4343: