DBA Data[Home] [Help]

APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1288: from hz_cust_account_roles a

1284:
1285:
1286: cursor c_cust_role(lin_party_id number,lin_custacct_site_id number,lin_custacct_id number) is
1287: select a.cust_account_role_id, a.status
1288: from hz_cust_account_roles a
1289: --, hz_cust_acct_sites_all c
1290: where
1291: a.role_type = 'CONTACT'
1292: and a.party_id = lin_party_id

Line 1484: from HZ_CUST_ACCOUNT_ROLES

1480: lc_customer_details c_customer_details%rowtype;
1481:
1482: CURSOR c_contact_partyid(lc_inv_to_cntct_id NUMBER) IS
1483: Select Party_id
1484: from HZ_CUST_ACCOUNT_ROLES
1485: where cust_account_role_id = lc_inv_to_cntct_id;
1486:
1487: lc_contact_partyid c_contact_partyid%rowtype;
1488: