DBA Data[Home] [Help]

APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1012: from hz_cust_account_roles a, hz_cust_acct_sites c

1008:
1009:
1010: CURSOR cust_role IS
1011: select a.cust_account_role_id
1012: from hz_cust_account_roles a, hz_cust_acct_sites c
1013: where a.role_type = 'CONTACT'
1014: and a.party_id = p_contact_party_id
1015: and a.cust_account_id = p_cust_account_id
1016: and a.cust_acct_site_id = c.cust_acct_site_id