DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_AGREEMENTS_ALL

Line 5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;

5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;
5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5252:
5253: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872

Line 5250: l_agreement_amount pa_agreements_all.amount%TYPE;

5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;
5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5252:
5253: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872
5254:

Line 5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;
5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5252:
5253: --l_mixed_resource_planned_flag VARCHAR2(1); --Added for Bug:-2625872
5254:
5255: l_plan_type_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE; --Bug 2661237

Line 8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

8488: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 8618: FROM pa_agreements_all

8614: /* txn currency should be the agreement currency */
8615: BEGIN
8616: SELECT agreement_currency_code
8617: INTO l_agr_curr_code
8618: FROM pa_agreements_all
8619: WHERE agreement_id = l_agreement_id;
8620: EXCEPTION
8621: WHEN NO_DATA_FOUND THEN
8622: IF p_pa_debug_mode = 'Y' THEN