APPS.OKE_FUNDSOURCE_PVT dependencies on PA_PROJECT_FUNDINGS

Line 313: update pa_project_fundings

309: ) is
310:
311: BEGIN
312:
313: update pa_project_fundings
314: set pm_product_code = G_PRODUCT_CODE,
315: pm_funding_reference = p_fund_allocation_id || '.1'
316: where project_funding_id = p_project_funding_id;
317:

Line 786: from pa_project_fundings

782: where k_header_id = p_object_id;
783:
784: cursor c_project (x_project_id number) is
785: select 'x'
786: from pa_project_fundings
787: where agreement_id = p_agreement_id
788: and project_id not in
789: (select to_number(sub_project_id)
790: from pa_fin_structures_links_v

Line 975: from pa_project_fundings

971: ) is
972:
973: cursor c_project_funding is
974: select 'x'
975: from pa_project_fundings
976: where agreement_id = p_agreement_id
977: FOR UPDATE OF project_funding_id NOWAIT;
978:
979: l_dummy_value varchar2(1) := '?';

Line 3525: from pa_project_fundings

3521: ) is
3522:
3523: cursor c_project_funding is
3524: select *
3525: from pa_project_fundings
3526: where agreement_id = p_agreement_id
3527: --Begin bug 15980946 change
3528: and budget_type_code in ( 'BASELINE', 'DRAFT')
3529: --End bug 15980946 change

Line 3547: from pa_project_fundings f,

3543: and g.set_of_books_id = p.set_of_books_id;
3544:
3545: cursor c_across is
3546: select 'x'
3547: from pa_project_fundings f,
3548: pa_projects_all p
3549: where nvl(p.org_id, -99) <> nvl(p_org_id, -99)
3550: and f.project_id = p.project_id
3551: and f.agreement_id = p_agreement_id;

Line 4167: from pa_project_fundings

4163: ) is
4164:
4165: cursor c_project_funding is
4166: select *
4167: from pa_project_fundings
4168: where agreement_id = p_agreement_id
4169: -- Begin 15980946 change
4170: and budget_type_code in ( 'BASELINE', 'DRAFT')
4171: -- End 15980946 change

Line 4189: from pa_project_fundings f,

4185: and g.set_of_books_id = p.set_of_books_id;
4186:
4187: cursor c_across (x_org_id number) is
4188: select 'x'
4189: from pa_project_fundings f,
4190: pa_projects_all p
4191: where nvl(p.org_id, -99) <> nvl(x_org_id, -99)
4192: and f.project_id = p.project_id
4193: and f.agreement_id = p_agreement_id;

Line 4198: from pa_project_fundings f,

4194:
4195: /*
4196: cursor c_update (x_org_id number) is
4197: select 'x'
4198: from pa_project_fundings f,
4199: pa_projects_all p
4200: where p.project_id = f.project_id
4201: and f.agreement_id = p_agreement_id
4202: and nvl(p.org_id, -99) <> nvl(x_org_id, -99);