APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on MO_GLOBAL

Line 658: and org_id <> mo_global.get_current_org_id()) then 0

654: else
655: (case when exists (select 'x'
656: from okl_subsidies_v
657: where subsidy_pool_id = okl_subsidy_pools_b.id
658: and org_id <> mo_global.get_current_org_id()) then 0
659: else 1 end)
660: end));
661:
662: l_pool_rec okl_sub_pool_rec;

Line 976: and org_id <> mo_global.get_current_org_id()) then 0

972: else
973: (case when exists (select 'x'
974: from okl_subsidies_v
975: where subsidy_pool_id = okl_subsidy_pools_b.id
976: and org_id <> mo_global.get_current_org_id()) then 0
977: else 1 end)
978: end))
979: ORDER BY subsidy_pool_name;
980:

Line 2337: and org_id <> mo_global.get_current_org_id()) then 0

2333: else
2334: (case when exists (select 'x'
2335: from okl_subsidies_v
2336: where subsidy_pool_id = okl_subsidy_pools_b.id
2337: and org_id <> mo_global.get_current_org_id()) then 0
2338: else 1 end)
2339: end));
2340:
2341: -- Cursor to fetch all the subsidy pools whose reamining budget is

Line 2363: and org_id <> mo_global.get_current_org_id()) then 0

2359: else
2360: (case when exists (select 'x'
2361: from okl_subsidies_v
2362: where subsidy_pool_id = okl_subsidy_pools_b.id
2363: and org_id <> mo_global.get_current_org_id()) then 0
2364: else 1 end)
2365: end));
2366:
2367: -- Cursor to fetch all the subsidy pools whose effective to date lies

Line 2388: and org_id <> mo_global.get_current_org_id()) then 0

2384: else
2385: (case when exists (select 'x'
2386: from okl_subsidies_v
2387: where subsidy_pool_id = okl_subsidy_pools_b.id
2388: and org_id <> mo_global.get_current_org_id()) then 0
2389: else 1 end)
2390: end));
2391:
2392: -- Cursor to fetch all the subsidy pools whose end of term days, calculated by pool's

Line 2413: and org_id <> mo_global.get_current_org_id()) then 0

2409: else
2410: (case when exists (select 'x'
2411: from okl_subsidies_v
2412: where subsidy_pool_id = okl_subsidy_pools_b.id
2413: and org_id <> mo_global.get_current_org_id()) then 0
2414: else 1 end)
2415: end));
2416:
2417: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;

Line 3096: and org_id <> mo_global.get_current_org_id()) then 0

3092: else
3093: (case when exists (select 'x'
3094: from okl_subsidies_v
3095: where subsidy_pool_id = chld.id
3096: and org_id <> mo_global.get_current_org_id()) then 0
3097: else 1 end)
3098: end))
3099: ORDER BY LEVEL,
3100: parent.subsidy_pool_name;

Line 3339: and org_id <> mo_global.get_current_org_id()) then 0

3335: else
3336: (case when exists (select 'x'
3337: from okl_subsidies_v
3338: where subsidy_pool_id = okl_subsidy_pools_b.id
3339: and org_id <> mo_global.get_current_org_id()) then 0
3340: else 1 end)
3341: end));
3342:
3343: -- Cursor to fetch all the subsidy pools whose reamining budget is

Line 3365: and org_id <> mo_global.get_current_org_id()) then 0

3361: else
3362: (case when exists (select 'x'
3363: from okl_subsidies_v
3364: where subsidy_pool_id = okl_subsidy_pools_b.id
3365: and org_id <> mo_global.get_current_org_id()) then 0
3366: else 1 end)
3367: end));
3368:
3369: -- Cursor to fetch all the subsidy pools whose effective to date lies

Line 3390: and org_id <> mo_global.get_current_org_id()) then 0

3386: else
3387: (case when exists (select 'x'
3388: from okl_subsidies_v
3389: where subsidy_pool_id = okl_subsidy_pools_b.id
3390: and org_id <> mo_global.get_current_org_id()) then 0
3391: else 1 end)
3392: end));
3393:
3394: -- Cursor to fetch all the subsidy pools whose end of term days, calculated by pool's

Line 3415: and org_id <> mo_global.get_current_org_id()) then 0

3411: else
3412: (case when exists (select 'x'
3413: from okl_subsidies_v
3414: where subsidy_pool_id = okl_subsidy_pools_b.id
3415: and org_id <> mo_global.get_current_org_id()) then 0
3416: else 1 end)
3417: end));
3418:
3419: x_errbuf VARCHAR2(1000);