APPS.PVX_MISC_PVT dependencies on PV_PARTNER_PROFILES

Line 83: FROM PV_PARTNER_PROFILES

79: */
80: -- Cursor : c_partner_detail
81: CURSOR c_partner_detail (cv_partner_profile_id IN NUMBER) IS
82: SELECT partner_party_id
83: FROM PV_PARTNER_PROFILES
84: WHERE partner_profile_id = cv_partner_profile_id;
85:
86:
87: -- Cursor records

Line 1823: FROM pv_partner_profiles

1819: RETCODE OUT NOCOPY VARCHAR2 ) IS
1820:
1821: CURSOR c_partners IS
1822: SELECT *
1823: FROM pv_partner_profiles
1824: Where status <> 'M'; -- hekkiral for bug fix 6694939. Merged records
1825: -- should not be touched.
1826:
1827: CURSOR c_relationship_status (p_party_id IN NUMBER, p_partner_party_id IN NUMBER) IS

Line 2109: from pv_partner_profiles pvpp, hz_parties hzp

2105: RETCODE OUT NOCOPY VARCHAR2 ) IS
2106:
2107: CURSOR c_get_partner_wo_accounts IS
2108: select distinct pvpp.partner_party_id, hzp.party_name
2109: from pv_partner_profiles pvpp, hz_parties hzp
2110: where pvpp.status = 'A'
2111: and hzp.party_id = pvpp.partner_party_id
2112: and hzp.status = 'A'
2113: and not exists

Line 2126: from pv_partner_profiles pvpp

2122: where jtfre.category= 'PARTY'
2123: and jtfre.user_id is not null
2124: and jtfre.source_id = hzr.party_id
2125: and hzr.object_id in (select pvpp.partner_party_id
2126: from pv_partner_profiles pvpp
2127: where status = 'A')
2128: and hzca.party_id = hzr.object_id
2129: and hzca.status = 'A'
2130: and hzr.relationship_code = 'EMPLOYEE_OF'