APPS.AS_ACCESS_PVT dependencies on PV_PARTNER_PROFILES

Line 1272: WHERE party_id = (SELECT PARTNER_PARTY_ID FROM PV_PARTNER_PROFILES WHERE PARTNER_ID = X_Party_Id)

1268: -- C_Party_Site_Exists_For_Partner_Party
1269: CURSOR C_Party_Site_Exists_Partner (X_Party_Id NUMBER, X_Party_Site_Id NUMBER) IS
1270: SELECT 1
1271: FROM AS_PARTY_ADDRESSES_V
1272: WHERE party_id = (SELECT PARTNER_PARTY_ID FROM PV_PARTNER_PROFILES WHERE PARTNER_ID = X_Party_Id)
1273: AND party_site_id = X_Party_Site_Id;
1274:
1275: BEGIN
1276: