DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_AGREEMENTS_ALL

Line 5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;

5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;
5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5268:
5269: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872

Line 5266: l_agreement_amount pa_agreements_all.amount%TYPE;

5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;
5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5268:
5269: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872
5270:

Line 5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;
5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5268:
5269: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872
5270:
5271: l_plan_type_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE; --Bug 2661237

Line 8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

8521: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8522: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8523: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8524: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); /* EnC */
8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 8659: FROM pa_agreements_all

8655: /* txn currency should be the agreement currency */
8656: BEGIN
8657: SELECT agreement_currency_code
8658: INTO l_agr_curr_code
8659: FROM pa_agreements_all
8660: WHERE agreement_id = l_agreement_id;
8661: EXCEPTION
8662: WHEN NO_DATA_FOUND THEN
8663: IF p_pa_debug_mode = 'Y' THEN