eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_AGREEMENT_PVT dependencies on OKE_K_FUND_ALLOCATIONS

Line 184: from oke_k_fund_allocations

180: RETURN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE is
181:
182: cursor c_allocation is
183: select *
184: from oke_k_fund_allocations
185: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id;
186:
187: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE := p_allocation_in_rec;
188: l_allocation_row OKE_K_FUND_ALLOCATIONS%ROWTYPE;

Line 188: l_allocation_row OKE_K_FUND_ALLOCATIONS%ROWTYPE;

184: from oke_k_fund_allocations
185: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id;
186:
187: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE := p_allocation_in_rec;
188: l_allocation_row OKE_K_FUND_ALLOCATIONS%ROWTYPE;
189:
190: BEGIN
191:
192: OPEN c_allocation;

Line 808: from oke_k_fund_allocations

804: cursor c_rate is
805: select pa_conversion_rate,
806: pa_conversion_date,
807: pa_conversion_type
808: from oke_k_fund_allocations
809: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id;
810:
811: cursor c_ou is
812: select org_id,

Line 1178: from oke_k_fund_allocations

1174: ) is
1175:
1176: cursor c_exist is
1177: select 'x'
1178: from oke_k_fund_allocations
1179: where funding_source_id = p_funding_source_id;
1180:
1181: cursor c_project is
1182: select 'x'

Line 1183: from oke_k_fund_allocations

1179: where funding_source_id = p_funding_source_id;
1180:
1181: cursor c_project is
1182: select 'x'
1183: from oke_k_fund_allocations
1184: where funding_source_id = p_funding_source_id
1185: and project_id is null
1186: and (amount <> 0 or agreement_version is not null);
1187:

Line 1506: from oke_k_fund_allocations

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
1508: and nvl(pa_flag, 'N') = 'N'
1509: );
1510:

Line 1516: from oke_k_fund_allocations

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
1518: );
1519:
1520: cursor c_allocation is

Line 1522: from oke_k_fund_allocations

1518: );
1519:
1520: cursor c_allocation is
1521: select sum(nvl(amount, 0))
1522: from oke_k_fund_allocations
1523: where funding_source_id = p_funding_source_id;
1524:
1525: i NUMBER;
1526: l_org_id_vc VARCHAR(10);

Line 2096: from oke_k_fund_allocations

2092: group by p.agreement_id, pm_agreement_reference, org_id;
2093:
2094: cursor c_allocation is
2095: select sum(nvl(amount, 0))
2096: from oke_k_fund_allocations
2097: where funding_source_id = p_funding_source_id;
2098:
2099: i NUMBER;
2100: l_org_id_vc VARCHAR(10);

Line 2381: from oke_k_fund_allocations o,

2377: select distinct
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

Line 2402: from oke_k_fund_allocations o,

2398: p.segment1 project_number,
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

Line 2420: from oke_k_fund_allocations o,

2416: o.amount,
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

Line 2445: from oke_k_fund_allocations o,

2441: o.amount,
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

Line 3098: from oke_k_fund_allocations f,

3094: f.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;

Line 3172: from oke_k_fund_allocations f,

3168: f.project_id,
3169: f.task_id,
3170: f.amount,
3171: f.funding_category
3172: from oke_k_fund_allocations f,
3173: pa_project_fundings p,
3174: pa_agreements_all a
3175: where funding_source_id = p_funding_in_rec.funding_source_id
3176: and f.project_id = x_project_id

Line 3199: from oke_k_fund_allocations f,

3195: f.project_id,
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'

Line 3224: from oke_k_fund_allocations f,

3220: f.task_id,
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

Line 3248: from oke_k_fund_allocations f,

3244: f.task_id,
3245: f.start_date_active,
3246: f.amount,
3247: f.funding_category
3248: from oke_k_fund_allocations f,
3249: pa_project_fundings p,
3250: pa_agreements_all a
3251: where funding_source_id = p_funding_in_rec.funding_source_id
3252: and f.project_id = x_project_id

Line 3265: from oke_k_fund_allocations

3261: order by 7, 8 desc, 10 desc;
3262:
3263: cursor c_allocation_sum is
3264: select sum(amount)
3265: from oke_k_fund_allocations
3266: where funding_source_id = p_funding_in_rec.funding_source_id;
3267:
3268: cursor c_source is
3269: select nvl(funding_across_ou, 'N')

Line 3276: oke_k_fund_allocations f,

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
3280: and f.amount <> 0

Line 4302: from oke_k_fund_allocations f,

4298: pa_conversion_date,
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:

Line 4311: from oke_k_fund_allocations o,

4307: cursor c_pa is
4308: select a.agreement_currency_code,
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

Line 4330: from oke_k_fund_allocations o,

4326: a.agreement_currency_code,
4327: --p.projfunc_currency_code,
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