DBA Data[Home] [Help]

APPS.IBE_BI_STR_MIG_PVT dependencies on IBE_MSITE_RESPS_B

Line 679: FROM ibe_msite_resps_b)

675: SELECT org_id
676: FROM
677: (SELECT distinct msite_id,
678: to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) org_id
679: FROM ibe_msite_resps_b)
680: WHERE org_id IS NOT NULL
681: GROUP BY org_id
682: HAVING count(*) = 1;
683:

Line 685: SELECT i.msite_id FROM ibe_msite_resps_b i

681: GROUP BY org_id
682: HAVING count(*) = 1;
683:
684: CURSOR c_msite_org(c_org_id NUMBER) IS
685: SELECT i.msite_id FROM ibe_msite_resps_b i
686: WHERE to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) = c_org_id;
687:
688: BEGIN
689: