APPS.OKE_AGREEMENT_PVT dependencies on PA_IMPLEMENTATIONS_ALL

Line 318: pa_implementations_all p

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

Line 2383: pa_implementations_all a

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

Line 2423: pa_implementations_all i

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

Line 2448: pa_implementations_all i

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

Line 3156: from pa_implementations_all

3152: = '-' || p_funding_in_rec.funding_source_id;
3153:
3154: cursor c_agreement5 (x_org_id number) is
3155: select multi_currency_billing_flag
3156: from pa_implementations_all
3157: where nvl(org_id, -99) = nvl(x_org_id, -99);
3158:
3159: cursor c_allocation(x_project_id number) is
3160: select distinct

Line 4315: -- pa_implementations_all i

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

Line 4334: pa_implementations_all i

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