APPS.OKE_AGREEMENT_PVT dependencies on PA_IMPLEMENTATIONS_ALL

Line 319: pa_implementations_all p

315:
316: cursor c_currency is
317: select currency_code
318: from gl_sets_of_books g,
319: pa_implementations_all p
320: where nvl(p_org_id, -99) = nvl(p.org_id, -99)
321: and p.set_of_books_id = g.set_of_books_id;
322:
323: l_ou_currency VARCHAR2(15);

Line 2399: pa_implementations_all a

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)
2403: and o.amount <> 0

Line 2439: pa_implementations_all i

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
2442: and o.project_id = p.project_id
2443: and nvl(a.org_id, -99) = nvl(p.org_id, -99)

Line 2464: pa_implementations_all i

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
2467: and o.project_id = x_project_id
2468: and nvl(a.org_id, -99) = nvl(i.org_id, -99)

Line 3177: from pa_implementations_all

3173: = '-' || p_funding_in_rec.funding_source_id;
3174:
3175: cursor c_agreement5 (x_org_id number) is
3176: select multi_currency_billing_flag
3177: from pa_implementations_all
3178: where nvl(org_id, -99) = nvl(x_org_id, -99);
3179:
3180: cursor c_allocation(x_project_id number) is
3181: select distinct

Line 4340: -- pa_implementations_all i

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)
4343: and s.funding_source_id = o.funding_source_id
4344: -- and o.project_id = p.project_id

Line 4359: pa_implementations_all i

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)
4362: and s.funding_source_id = o.funding_source_id
4363: and o.project_id = p.project_id