APPS.IBE_MERGE_PVT dependencies on IBE_MSITES_B

Line 1259: From ibe_msite_prty_accss a, ibe_msites_b b

1255: for update nowait;
1256:
1257: CURSOR merge_records(p_party_id NUMBER) IS
1258: Select a.msite_id, b.party_access_code
1259: From ibe_msite_prty_accss a, ibe_msites_b b
1260: Where party_id = p_party_id and a.msite_id=b.msite_id and b.site_type = 'I';
1261:
1262:
1263: l_msite_prty_accss_id IBE_MSITE_PRTY_ACCSS.MSITE_PRTY_ACCSS_ID%TYPE;

Line 1268: l_party_access_code IBE_MSITES_B.PARTY_ACCESS_CODE%TYPE;

1264: l_merge_reason_code VARCHAR2(30);
1265: l_count NUMBER(10) := 0;
1266: RESOURCE_BUSY EXCEPTION;
1267: l_msite_id IBE_MSITE_PRTY_ACCSS.MSITE_ID%TYPE;
1268: l_party_access_code IBE_MSITES_B.PARTY_ACCESS_CODE%TYPE;
1269: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1270:
1271: Begin
1272:

Line 1324: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b

1320: last_update_date = hz_utility_pub.last_update_date,
1321: last_updated_by = hz_utility_pub.user_id,
1322: last_update_login = hz_utility_pub.last_update_login
1323: Where party_id = p_from_fk_id and exists (
1324: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1325: where party_id=p_to_fk_id and a.msite_id<>l_msite_id
1326: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code
1327: and b.site_type = 'I'
1328: );