APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_SUBSIDIES_V

Line 656: from okl_subsidies_v

652: WHERE id = cp_pool_id
653: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 974: from okl_subsidies_v

970: WHERE subsidy_pool_id = cp_pool_id
971: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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))

Line 2335: from okl_subsidies_v

2331: ELSE ((total_budgets - NVL(total_subsidy_amount,0)) * 100) /total_budgets END <= cp_percent
2332: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 2361: from okl_subsidies_v

2357: AND currency_code = cp_currency
2358: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 2386: from okl_subsidies_v

2382: AND TRUNC(effective_to_date) <= TRUNC(cp_date)
2383: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 2411: from okl_subsidies_v

2407: AND trunc(effective_to_date) - trunc(sysdate) between 0 and cp_days
2408: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 3094: from okl_subsidies_v

3090: CONNECT BY PRIOR chld.id = chld.subsidy_pool_id START WITH chld.id = cp_pool_id
3091: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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))

Line 3337: from okl_subsidies_v

3333: ELSE ((total_budgets - NVL(total_subsidy_amount,0)) * 100) /total_budgets END <= cp_percent
3334: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 3363: from okl_subsidies_v

3359: AND currency_code = cp_currency
3360: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 3388: from okl_subsidies_v

3384: AND TRUNC(effective_to_date) <= TRUNC(cp_date)
3385: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));

Line 3413: from okl_subsidies_v

3409: AND trunc(effective_to_date) - trunc(sysdate) between 0 and cp_days
3410: AND ( 1 = (case when nvl(fnd_profile.value('OKLSUBPOOLGLOBALACCESS'),'N') = 'Y' then 1
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));