APPS.CSP_PARTS_ORDER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1550: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

1546:
1547: cursor get_valid_contact_id (v_party_id number, v_org_id number) is
1548: SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
1549: FROM
1550: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1551: HZ_CUST_SITE_USES_ALL SITE_USE,
1552: HZ_CUST_ACCT_SITES_all ADDR
1553: WHERE
1554: ACCT_ROLE.party_id = v_party_id

Line 1894: FROM HZ_CUST_ACCOUNT_ROLES

1890:
1891: if l_pr_ship_to_contact_id <> -9999 then
1892: SELECT party_id
1893: into l_ship_to_contact_id
1894: FROM HZ_CUST_ACCOUNT_ROLES
1895: WHERE cust_account_role_id = l_pr_ship_to_contact_id;
1896: end if;
1897: -- end of bug # 13707506
1898: