DBA Data[Home] [Help]

APPS.PA_AGREEMENT_PUB dependencies on PA_PROJECTS_ALL

Line 793: FROM pa_projects_all

789:
790: /* Bug 2437469- BEGIN */
791:
792: SELECT invproc_currency_type INTO l_invproc_currency_type
793: FROM pa_projects_all
794: WHERE project_id=l_funding_in_rec.project_id;
795:
796: IF l_invproc_currency_type='FUNDING_CURRENCY'
797: THEN

Line 5955: FROM pa_projects_all

5951:
5952:
5953: CURSOR proj_dates IS
5954: SELECT start_date, completion_date,nvl(baseline_funding_flag,'N') baseline_funding_flag
5955: FROM pa_projects_all
5956: WHERE project_id = p_pa_project_id;
5957:
5958: res_info_rec res_info%ROWTYPE;
5959: proj_dates_rec proj_dates%ROWTYPE;

Line 5961: l_project_id pa_projects_all.project_id%type;

5957:
5958: res_info_rec res_info%ROWTYPE;
5959: proj_dates_rec proj_dates%ROWTYPE;
5960:
5961: l_project_id pa_projects_all.project_id%type;
5962: l_budget_version_id NUMBER;
5963: l_funding_level VARCHAR2(1);
5964: l_budget_entry_method_code VARCHAR2(30);
5965: