DBA Data[Home] [Help]

APPS.OKE_ALLOCATION_PVT dependencies on PA_PROJECT_FUNDINGS

Line 2921: from pa_project_fundings p,

2917: and a.fund_allocation_id = p_fund_allocation_id;
2918:
2919: cursor c_proj_funding(x_length number) is
2920: select project_funding_id, org_id, pm_funding_reference
2921: from pa_project_fundings p,
2922: pa_agreements_all a
2923: where p.pm_product_code = G_PRODUCT_CODE
2924: and a.agreement_id = p.agreement_id
2925: and substr(pm_funding_reference, 1, x_length + 1) = p_fund_allocation_id || '.';