DBA Data[Home] [Help]

APPS.PV_TAP_BES_PKG dependencies on HZ_PARTIES

Line 1549: hz_parties hzp,

1545: hzp.party_name,
1546: hzpr.party_name party_name_r
1547: FROM pv_partner_profiles ppp,
1548: jtf_rs_resource_extns jrr,
1549: hz_parties hzp,
1550: hz_parties hzpr,
1551: hz_party_relationship_v hzprv
1552: WHERE ppp.partner_party_id = cv_partner_party_id
1553: AND ppp.partner_id = hzp.party_id

Line 1550: hz_parties hzpr,

1546: hzpr.party_name party_name_r
1547: FROM pv_partner_profiles ppp,
1548: jtf_rs_resource_extns jrr,
1549: hz_parties hzp,
1550: hz_parties hzpr,
1551: hz_party_relationship_v hzprv
1552: WHERE ppp.partner_party_id = cv_partner_party_id
1553: AND ppp.partner_id = hzp.party_id
1554: AND ppp.status = 'A'

Line 2136: HZ_PARTIES PARTY,

2132: -- Cursor l_cust_is_partner_csr.
2133: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS
2134: SELECT /*+ index(p) */ partner_id
2135: FROM HZ_CONTACT_POINTS CP,
2136: HZ_PARTIES PARTY,
2137: pv_partner_profiles p
2138: WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2139: AND CP.owner_table_id = p.partner_party_id
2140: AND CP.owner_table_name(+) = 'HZ_PARTIES'

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

2136: HZ_PARTIES PARTY,
2137: pv_partner_profiles p
2138: WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2139: AND CP.owner_table_id = p.partner_party_id
2140: AND CP.owner_table_name(+) = 'HZ_PARTIES'
2141: AND CP.status(+) = 'A'
2142: AND CP.primary_flag(+) = 'Y'
2143: AND CP.contact_point_type(+) = 'PHONE'
2144: AND CP.owner_table_id(+) = PARTY.party_id

Line 2155: -- HZ_PARTIES PARTY

2151: -- SELECT /*+ index(p) */ partner_id
2152: -- FROM pv_partner_profiles p
2153: -- WHERE exists ( SELECT 'Y'
2154: -- FROM HZ_CONTACT_POINTS CP,
2155: -- HZ_PARTIES PARTY
2156: -- WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2157: -- AND CP.owner_table_id = p.partner_party_id
2158: -- AND CP.owner_table_name(+) = 'HZ_PARTIES'
2159: -- AND CP.status(+) = 'A'

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

2154: -- FROM HZ_CONTACT_POINTS CP,
2155: -- HZ_PARTIES PARTY
2156: -- WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2157: -- AND CP.owner_table_id = p.partner_party_id
2158: -- AND CP.owner_table_name(+) = 'HZ_PARTIES'
2159: -- AND CP.status(+) = 'A'
2160: -- AND CP.primary_flag(+) = 'Y'
2161: -- AND CP.contact_point_type(+) = 'PHONE'
2162: -- AND CP.owner_table_id(+) = PARTY.party_id