DBA Data[Home] [Help]

APPS.WSH_WF dependencies on HZ_CUST_ACCOUNTS

Line 1402: hz_cust_accounts

1398: CURSOR get_party(c_contact_type in varchar2, c_contact_id in number) IS --TCA view Removal Starts
1399: SELECT
1400: party_id
1401: FROM
1402: hz_cust_accounts
1403: WHERE
1404: cust_account_id/*customer_id*/ = c_contact_id
1405: AND c_contact_type = 'CUSTOMER'
1406: UNION

Line 1413: hz_cust_accounts Role_acct

1409: FROM
1410: hz_cust_account_roles Acct_role,
1411: hz_relationships Rel,
1412: hz_org_contacts Org_cont,
1413: hz_cust_accounts Role_acct
1414: WHERE
1415: acct_role.cust_account_role_id/*contact id*/ = c_contact_id
1416: AND acct_role.party_id = rel.party_id
1417: AND acct_role.Role_type = 'CONTACT'