[Home] [Help]
1499: group by p.agreement_id, pm_agreement_reference, org_id;
1500:
1501: cursor c_org_count2 is
1502: select count(distinct org_id)
1503: from pa_projects_all
1504: where project_id in
1505: (select distinct project_id
1506: from oke_k_fund_allocations
1507: where funding_source_id = p_funding_source_id
1509: );
1510:
1511: cursor c_org_count is
1512: select count(distinct org_id)
1513: from pa_projects_all
1514: where project_id in
1515: (select distinct project_id
1516: from oke_k_fund_allocations
1517: where funding_source_id = p_funding_source_id
2378: nvl(p.org_id, -99) org_id,
2379: a.multi_currency_billing_flag,
2380: p.projfunc_currency_code
2381: from oke_k_fund_allocations o,
2382: pa_projects_all p,
2383: pa_implementations_all a
2384: where funding_source_id = p_funding_in_rec.funding_source_id
2385: and o.project_id = p.project_id
2386: and nvl(a.org_id, -99) = nvl(p.org_id, -99)
2399: o.amount,
2400: p.multi_currency_billing_flag,
2401: p.projfunc_currency_code
2402: from oke_k_fund_allocations o,
2403: pa_projects_all p
2404: where funding_source_id = p_funding_in_rec.funding_source_id
2405: and o.project_id = p.project_id
2406: and nvl(p.org_id, -99) = x_org_id
2407: and o.amount <> 0
2417: a.agreement_id,
2418: o.start_date_active,
2419: o.funding_category
2420: from oke_k_fund_allocations o,
2421: pa_projects_all p,
2422: pa_agreements_all a,
2423: pa_implementations_all i
2424: where funding_source_id = p_funding_in_rec.funding_source_id
2425: and o.project_id = x_project_id
2442: a.agreement_id,
2443: o.start_date_active ,
2444: o.funding_category
2445: from oke_k_fund_allocations o,
2446: pa_projects_all p,
2447: pa_agreements_all a,
2448: pa_implementations_all i
2449: where funding_source_id = p_funding_in_rec.funding_source_id
2450: and o.project_id = p.project_id
3095: f.task_id,
3096: org_id,
3097: p.segment1 project_number
3098: from oke_k_fund_allocations f,
3099: pa_projects_all p
3100: where funding_source_id = p_funding_in_rec.funding_source_id
3101: and f.project_id = p.project_id
3102: order by p.project_id;
3103:
3196: f.task_id,
3197: f.amount,
3198: f.funding_category
3199: from oke_k_fund_allocations f,
3200: pa_projects_all p
3201: where funding_source_id = p_funding_in_rec.funding_source_id
3202: and f.project_id = x_project_id
3203: and nvl(insert_update_flag, 'N') = 'Y'
3204: and agreement_version is null
3221: f.start_date_active,
3222: f.amount,
3223: f.funding_category
3224: from oke_k_fund_allocations f,
3225: pa_projects_all p
3226: where funding_source_id = p_funding_in_rec.funding_source_id
3227: and f.project_id = x_project_id
3228: and p.project_id = x_project_id
3229: and nvl(insert_update_flag, 'N') = 'Y'
3271: where funding_source_id = p_funding_in_rec.funding_source_id;
3272:
3273: cursor c_non_mcb is
3274: select p.segment1
3275: from pa_projects_all p,
3276: oke_k_fund_allocations f,
3277: oke_k_funding_sources s
3278: where p.project_id = f.project_id
3279: and f.funding_source_id = p_funding_in_rec.funding_source_id
4299: p.org_id,
4300: p.segment1 project_number--,
4301: -- pa_flag
4302: from oke_k_fund_allocations f,
4303: pa_projects_all p
4304: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id
4305: and f.project_id = p.project_id;
4306:
4307: cursor c_pa is
4309: nvl(a.org_id, -99),
4310: s.currency_code
4311: from oke_k_fund_allocations o,
4312: pa_agreements_all a,
4313: --pa_projects_all p,
4314: oke_k_funding_sources s
4315: -- pa_implementations_all i
4316: where a.agreement_id = p_allocation_in_rec.agreement_id
4317: -- and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4328: nvl(a.org_id, -99),
4329: i.multi_currency_billing_flag
4330: from oke_k_fund_allocations o,
4331: pa_agreements_all a,
4332: pa_projects_all p,
4333: oke_k_funding_sources s,
4334: pa_implementations_all i
4335: where a.agreement_id = p_allocation_in_rec.agreement_id
4336: and nvl(i.org_id, -99) = nvl(a.org_id, -99)