APPS.PV_TAP_BES_PKG dependencies on PV_PARTNER_PROFILES

Line 1352: FROM pv_partner_profiles

1348:
1349: -- Cursor l_cust_is_partner_csr.
1350: CURSOR l_cust_is_partner_csr (cv_partner_party_id NUMBER) IS
1351: SELECT partner_id
1352: FROM pv_partner_profiles
1353: WHERE partner_party_id = cv_partner_party_id
1354: AND status = 'A';
1355:
1356: -- Cursor l_chng_partner_exist_csr.

Line 1369: -- PV_PARTNER_PROFILES table.

1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366:
1367: -- Check if the supplied party_id point to a Partner or a Customer.
1368: -- If it's point to a PARTNER Org, then there should be a record exists in
1369: -- PV_PARTNER_PROFILES table.
1370:
1371: OPEN l_cust_is_partner_csr(p_party_id );
1372: FETCH l_cust_is_partner_csr INTO l_partner_id;
1373:

Line 1547: FROM pv_partner_profiles ppp,

1543: jrr.object_version_number,
1544: jrr.source_name,
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

Line 1723: pv_partner_profiles ppp

1719: -- Cursor l_cust_is_partner_csr.
1720: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1721: SELECT partner_id
1722: FROM hz_party_sites hzps,
1723: pv_partner_profiles ppp
1724: WHERE hzps.party_site_id = cv_party_site_id
1725: AND hzps.status = 'A'
1726: AND ppp.partner_party_id = hzps.party_id
1727: AND ppp.status = 'A';

Line 1745: -- PV_PARTNER_PROFILES table.

1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: -- Check if the supplied party_site_id point to a Partner or a Customer.
1744: -- If it's point to a PARTNER Org, then there should be a record exists in
1745: -- PV_PARTNER_PROFILES table.
1746:
1747: OPEN l_cust_is_partner_csr(p_party_site_id );
1748: FETCH l_cust_is_partner_csr INTO l_partner_id;
1749:

Line 1922: pv_partner_profiles ppp

1918: -- Cursor l_cust_is_partner_csr.
1919: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1920: SELECT ppp.partner_id
1921: FROM hz_party_sites hps,
1922: pv_partner_profiles ppp
1923: -- Fixed the isse by pointing the LOCATION_ID to partner's party.
1924: -- WHERE ppp.partner_id = hps.party_id
1925: WHERE ppp.partner_party_id = hps.party_id
1926: AND ppp.status = 'A'

Line 1944: -- PV_PARTNER_PROFILES table.

1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: -- Check if the supplied party_id point to a Partner or a Customer.
1943: -- If it's point to a PARTNER Org, then there should be a record exists in
1944: -- PV_PARTNER_PROFILES table.
1945:
1946: OPEN l_cust_is_partner_csr(p_location_id );
1947: FETCH l_cust_is_partner_csr INTO l_partner_id;
1948:

Line 2137: pv_partner_profiles p

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

Line 2152: -- FROM pv_partner_profiles p

2148:
2149:
2150: -- Commented for the bug fix # 4141409.
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

Line 2180: -- PV_PARTNER_PROFILES table.

2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177:
2178: -- Check if the supplied party_id point to a Partner or a Customer.
2179: -- If it's point to a PARTNER Org, then there should be a record exists in
2180: -- PV_PARTNER_PROFILES table.
2181:
2182: OPEN l_cust_is_partner_csr(p_contact_point_id );
2183: FETCH l_cust_is_partner_csr INTO l_partner_id;
2184: IF l_cust_is_partner_csr%FOUND THEN