APPS.OKE_FUNDSOURCE_PVT dependencies on PA_PROJECT_FUNDINGS

Line 299: update pa_project_fundings

295: ) is
296:
297: BEGIN
298:
299: update pa_project_fundings
300: set pm_product_code = G_PRODUCT_CODE,
301: pm_funding_reference = p_fund_allocation_id || '.1'
302: where project_funding_id = p_project_funding_id;
303:

Line 772: from pa_project_fundings

768: where k_header_id = p_object_id;
769:
770: cursor c_project (x_project_id number) is
771: select 'x'
772: from pa_project_fundings
773: where agreement_id = p_agreement_id
774: and project_id not in
775: (select to_number(sub_project_id)
776: from pa_fin_structures_links_v

Line 961: from pa_project_fundings

957: ) is
958:
959: cursor c_project_funding is
960: select 'x'
961: from pa_project_fundings
962: where agreement_id = p_agreement_id
963: FOR UPDATE OF project_funding_id NOWAIT;
964:
965: l_dummy_value varchar2(1) := '?';

Line 3346: from pa_project_fundings

3342: ) is
3343:
3344: cursor c_project_funding is
3345: select *
3346: from pa_project_fundings
3347: where agreement_id = p_agreement_id
3348: order by allocated_amount desc;
3349:
3350: cursor c_pool_party_date is

Line 3365: from pa_project_fundings f,

3361: and g.set_of_books_id = p.set_of_books_id;
3362:
3363: cursor c_across is
3364: select 'x'
3365: from pa_project_fundings f,
3366: pa_projects_all p
3367: where nvl(p.org_id, -99) <> nvl(p_org_id, -99)
3368: and f.project_id = p.project_id
3369: and f.agreement_id = p_agreement_id;

Line 3970: from pa_project_fundings

3966: ) is
3967:
3968: cursor c_project_funding is
3969: select *
3970: from pa_project_fundings
3971: where agreement_id = p_agreement_id
3972: order by allocated_amount desc;
3973:
3974: cursor c_agreement is

Line 3989: from pa_project_fundings f,

3985: and g.set_of_books_id = p.set_of_books_id;
3986:
3987: cursor c_across (x_org_id number) is
3988: select 'x'
3989: from pa_project_fundings f,
3990: pa_projects_all p
3991: where nvl(p.org_id, -99) <> nvl(x_org_id, -99)
3992: and f.project_id = p.project_id
3993: and f.agreement_id = p_agreement_id;

Line 3998: from pa_project_fundings f,

3994:
3995: /*
3996: cursor c_update (x_org_id number) is
3997: select 'x'
3998: from pa_project_fundings f,
3999: pa_projects_all p
4000: where p.project_id = f.project_id
4001: and f.agreement_id = p_agreement_id
4002: and nvl(p.org_id, -99) <> nvl(x_org_id, -99);