APPS.PV_TAP_BES_PKG dependencies on HZ_PARTIES

Line 1965: HZ_PARTIES PARTY,

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
1969: AND CP.owner_table_name(+) = 'HZ_PARTIES'

Line 1969: AND CP.owner_table_name(+) = 'HZ_PARTIES'

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
1969: AND CP.owner_table_name(+) = 'HZ_PARTIES'
1970: AND CP.status(+) = 'A'
1971: AND CP.primary_flag(+) = 'Y'
1972: AND CP.contact_point_type(+) = 'PHONE'
1973: AND CP.owner_table_id(+) = PARTY.party_id

Line 1984: -- HZ_PARTIES PARTY

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'
1988: -- AND CP.status(+) = 'A'

Line 1987: -- AND CP.owner_table_name(+) = 'HZ_PARTIES'

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'
1988: -- AND CP.status(+) = 'A'
1989: -- AND CP.primary_flag(+) = 'Y'
1990: -- AND CP.contact_point_type(+) = 'PHONE'
1991: -- AND CP.owner_table_id(+) = PARTY.party_id