APPS.IBE_MERGE_PVT dependencies on IBE_MSITES_B

Line 1301: From ibe_msite_prty_accss a, ibe_msites_b b

1297: for update nowait;
1298:
1299: CURSOR merge_records(p_party_id NUMBER) IS
1300: Select a.msite_id, b.party_access_code
1301: From ibe_msite_prty_accss a, ibe_msites_b b
1302: Where party_id = p_party_id and a.msite_id=b.msite_id and b.site_type = 'I';
1303:
1304:
1305: l_msite_prty_accss_id IBE_MSITE_PRTY_ACCSS.MSITE_PRTY_ACCSS_ID%TYPE;

Line 1310: l_party_access_code IBE_MSITES_B.PARTY_ACCESS_CODE%TYPE;

1306: l_merge_reason_code VARCHAR2(30);
1307: l_count NUMBER(10) := 0;
1308: RESOURCE_BUSY EXCEPTION;
1309: l_msite_id IBE_MSITE_PRTY_ACCSS.MSITE_ID%TYPE;
1310: l_party_access_code IBE_MSITES_B.PARTY_ACCESS_CODE%TYPE;
1311: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1312:
1313: Begin
1314:

Line 1363: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b

1359: last_update_date = hz_utility_pub.last_update_date,
1360: last_updated_by = hz_utility_pub.user_id,
1361: last_update_login = hz_utility_pub.last_update_login
1362: Where party_id = p_from_fk_id and exists (
1363: select 1 from IBE_MSITE_PRTY_ACCSS a, IBE_MSITES_B b
1364: where party_id=p_to_fk_id and a.msite_id<>l_msite_id
1365: and a.msite_id = b.msite_id and b.party_access_code = l_party_access_code
1366: and b.site_type = 'I'
1367: );