DBA Data[Home] [Help]

APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1285: from hz_cust_account_roles a

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

Line 1481: from HZ_CUST_ACCOUNT_ROLES

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