DBA Data[Home] [Help]

APPS.PV_TAP_BES_PKG dependencies on HZ_CONTACT_POINTS

Line 1964: FROM HZ_CONTACT_POINTS CP,

1960:
1961: -- Cursor l_cust_is_partner_csr.
1962: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS
1963: SELECT /*+ index(p) */ partner_id
1964: FROM HZ_CONTACT_POINTS CP,
1965: HZ_PARTIES PARTY,
1966: pv_partner_profiles p
1967: WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
1968: AND CP.owner_table_id = p.partner_party_id

Line 1983: -- FROM HZ_CONTACT_POINTS CP,

1979: -- Commented for the bug fix # 4141409.
1980: -- SELECT /*+ index(p) */ partner_id
1981: -- FROM pv_partner_profiles p
1982: -- WHERE exists ( SELECT 'Y'
1983: -- FROM HZ_CONTACT_POINTS CP,
1984: -- HZ_PARTIES PARTY
1985: -- WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
1986: -- AND CP.owner_table_id = p.partner_party_id
1987: -- AND CP.owner_table_name(+) = 'HZ_PARTIES'