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 1552: pv_partner_profiles ppp

1548: -- Cursor l_cust_is_partner_csr.
1549: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1550: SELECT partner_id
1551: FROM hz_party_sites hzps,
1552: pv_partner_profiles ppp
1553: WHERE hzps.party_site_id = cv_party_site_id
1554: AND hzps.status = 'A'
1555: AND ppp.partner_party_id = hzps.party_id
1556: AND ppp.status = 'A';

Line 1574: -- PV_PARTNER_PROFILES table.

1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571:
1572: -- Check if the supplied party_site_id point to a Partner or a Customer.
1573: -- If it's point to a PARTNER Org, then there should be a record exists in
1574: -- PV_PARTNER_PROFILES table.
1575:
1576: OPEN l_cust_is_partner_csr(p_party_site_id );
1577: FETCH l_cust_is_partner_csr INTO l_partner_id;
1578:

Line 1751: pv_partner_profiles ppp

1747: -- Cursor l_cust_is_partner_csr.
1748: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1749: SELECT ppp.partner_id
1750: FROM hz_party_sites hps,
1751: pv_partner_profiles ppp
1752: -- Fixed the isse by pointing the LOCATION_ID to partner's party.
1753: -- WHERE ppp.partner_id = hps.party_id
1754: WHERE ppp.partner_party_id = hps.party_id
1755: AND ppp.status = 'A'

Line 1773: -- PV_PARTNER_PROFILES table.

1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: -- Check if the supplied party_id point to a Partner or a Customer.
1772: -- If it's point to a PARTNER Org, then there should be a record exists in
1773: -- PV_PARTNER_PROFILES table.
1774:
1775: OPEN l_cust_is_partner_csr(p_location_id );
1776: FETCH l_cust_is_partner_csr INTO l_partner_id;
1777:

Line 1966: pv_partner_profiles p

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

Line 1981: -- FROM pv_partner_profiles p

1977:
1978:
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

Line 2009: -- PV_PARTNER_PROFILES table.

2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006:
2007: -- Check if the supplied party_id point to a Partner or a Customer.
2008: -- If it's point to a PARTNER Org, then there should be a record exists in
2009: -- PV_PARTNER_PROFILES table.
2010:
2011: OPEN l_cust_is_partner_csr(p_contact_point_id );
2012: FETCH l_cust_is_partner_csr INTO l_partner_id;
2013: IF l_cust_is_partner_csr%FOUND THEN