[Home] [Help]
1514: group by p.agreement_id, pm_agreement_reference, org_id;
1515:
1516: cursor c_org_count2 is
1517: select count(distinct org_id)
1518: from pa_projects_all
1519: where project_id in
1520: (select distinct project_id
1521: from oke_k_fund_allocations
1522: where funding_source_id = p_funding_source_id
1524: );
1525:
1526: cursor c_org_count is
1527: select count(distinct org_id)
1528: from pa_projects_all
1529: where project_id in
1530: (select distinct project_id
1531: from oke_k_fund_allocations
1532: where funding_source_id = p_funding_source_id
2394: nvl(p.org_id, -99) org_id,
2395: a.multi_currency_billing_flag,
2396: p.projfunc_currency_code
2397: from oke_k_fund_allocations o,
2398: pa_projects_all p,
2399: pa_implementations_all a
2400: where funding_source_id = p_funding_in_rec.funding_source_id
2401: and o.project_id = p.project_id
2402: and nvl(a.org_id, -99) = nvl(p.org_id, -99)
2415: o.amount,
2416: p.multi_currency_billing_flag,
2417: p.projfunc_currency_code
2418: from oke_k_fund_allocations o,
2419: pa_projects_all p
2420: where funding_source_id = p_funding_in_rec.funding_source_id
2421: and o.project_id = p.project_id
2422: and nvl(p.org_id, -99) = x_org_id
2423: and o.amount <> 0
2433: a.agreement_id,
2434: o.start_date_active,
2435: o.funding_category
2436: from oke_k_fund_allocations o,
2437: pa_projects_all p,
2438: pa_agreements_all a,
2439: pa_implementations_all i
2440: where funding_source_id = p_funding_in_rec.funding_source_id
2441: and o.project_id = x_project_id
2458: a.agreement_id,
2459: o.start_date_active ,
2460: o.funding_category
2461: from oke_k_fund_allocations o,
2462: pa_projects_all p,
2463: pa_agreements_all a,
2464: pa_implementations_all i
2465: where funding_source_id = p_funding_in_rec.funding_source_id
2466: and o.project_id = p.project_id
3116: f.task_id,
3117: org_id,
3118: p.segment1 project_number
3119: from oke_k_fund_allocations f,
3120: pa_projects_all p
3121: where funding_source_id = p_funding_in_rec.funding_source_id
3122: and f.project_id = p.project_id
3123: order by p.project_id;
3124:
3217: f.task_id,
3218: f.amount,
3219: f.funding_category
3220: from oke_k_fund_allocations f,
3221: pa_projects_all p
3222: where funding_source_id = p_funding_in_rec.funding_source_id
3223: and f.project_id = x_project_id
3224: and nvl(insert_update_flag, 'N') = 'Y'
3225: and agreement_version is null
3242: f.start_date_active,
3243: f.amount,
3244: f.funding_category
3245: from oke_k_fund_allocations f,
3246: pa_projects_all p
3247: where funding_source_id = p_funding_in_rec.funding_source_id
3248: and f.project_id = x_project_id
3249: and p.project_id = x_project_id
3250: and nvl(insert_update_flag, 'N') = 'Y'
3292: where funding_source_id = p_funding_in_rec.funding_source_id;
3293:
3294: cursor c_non_mcb is
3295: select p.segment1
3296: from pa_projects_all p,
3297: oke_k_fund_allocations f,
3298: oke_k_funding_sources s
3299: where p.project_id = f.project_id
3300: and f.funding_source_id = p_funding_in_rec.funding_source_id
4324: p.org_id,
4325: p.segment1 project_number--,
4326: -- pa_flag
4327: from oke_k_fund_allocations f,
4328: pa_projects_all p
4329: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id
4330: and f.project_id = p.project_id;
4331:
4332: cursor c_pa is
4334: nvl(a.org_id, -99),
4335: s.currency_code
4336: from oke_k_fund_allocations o,
4337: pa_agreements_all a,
4338: --pa_projects_all p,
4339: oke_k_funding_sources s
4340: -- pa_implementations_all i
4341: where a.agreement_id = p_allocation_in_rec.agreement_id
4342: -- and nvl(i.org_id, -99) = nvl(a.org_id, -99)
4353: nvl(a.org_id, -99),
4354: i.multi_currency_billing_flag
4355: from oke_k_fund_allocations o,
4356: pa_agreements_all a,
4357: pa_projects_all p,
4358: oke_k_funding_sources s,
4359: pa_implementations_all i
4360: where a.agreement_id = p_allocation_in_rec.agreement_id
4361: and nvl(i.org_id, -99) = nvl(a.org_id, -99)