APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_AGREEMENTS_ALL

Line 902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
906: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 975: -- >>>> BUG FIX 2730016: check pa_agreements_all as well

971: select projfunc_currency_code
972: into x_project_currency
973: from pa_projects_all
974: where project_id = p_project_id;
975: -- >>>> BUG FIX 2730016: check pa_agreements_all as well
976: select ci_id,
977: agreement_id
978: into l_ci_id,
979: l_agreement_id

Line 985: from pa_agreements_all

981: where budget_version_id = p_budget_version_id;
982: if l_ci_id is not null and l_agreement_id is not null then
983: select nvl (agreement_currency_code, 'ANY')
984: into l_agreement_currency_code
985: from pa_agreements_all
986: where agreement_id = l_agreement_id;
987: if l_agreement_currency_code <> 'ANY' then
988: x_project_currency := l_agreement_currency_code;
989: end if;

Line 2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679

2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679
2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679
2434:
2435: l_is_cost_locked_by_user VARCHAR2(1);
2436: l_is_rev_locked_by_user VARCHAR2(1);

Line 2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679

2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679
2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679
2434:
2435: l_is_cost_locked_by_user VARCHAR2(1);
2436: l_is_rev_locked_by_user VARCHAR2(1);
2437: l_cost_locked_by_person_id NUMBER;

Line 2529: from pa_agreements_all

2525:
2526: if p_ci_id is not null and l_agreement_id is not null then
2527: select nvl (agreement_currency_code, 'ANY')
2528: into l_agreement_currency_code
2529: from pa_agreements_all
2530: where agreement_id = l_agreement_id;
2531: if l_agreement_currency_code <> 'ANY' then
2532: x_project_currency := l_agreement_currency_code;
2533: end if;