DBA Data[Home] [Help]

APPS.AS_ACCESS_PVT dependencies on AS_PARTY_ADDRESSES_V

Line 1264: FROM AS_PARTY_ADDRESSES_V

1260: l_return_status VARCHAR2(1);
1261:
1262: CURSOR C_Party_Site_Exists (X_Party_Id NUMBER, X_Party_Site_Id NUMBER) IS
1263: SELECT 1
1264: FROM AS_PARTY_ADDRESSES_V
1265: WHERE party_id = X_Party_Id
1266: AND party_site_id = X_Party_Site_Id;
1267:
1268: -- C_Party_Site_Exists_For_Partner_Party

Line 1271: FROM AS_PARTY_ADDRESSES_V

1267:
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