APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_PROJ_XL_AMT_TYPES

Line 2545: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt

2541:
2542:
2543: UPDATE pa_fp_webadi_upload_inf inf
2544: SET amount_type_code = (SELECT pl.lookup_code
2545: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt
2546: WHERE lookup_type=l_lookup_type
2547: AND meaning=inf.amount_type_name
2548: AND xlt.project_id=p_version_info_rec.x_project_id
2549: AND xlt.fin_plan_type_id=p_version_info_rec.x_fin_plan_type_id

Line 12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,

12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
12159: l_proj_fp_options_rec proj_fp_options_rec;
12160:
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
12163: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
12164: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
12165: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
12166: IS

Line 12163: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,

12159: l_proj_fp_options_rec proj_fp_options_rec;
12160:
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
12163: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
12164: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
12165: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
12166: IS
12167: SELECT amt.amount_type_code,

Line 12164: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,

12160:
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
12163: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
12164: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
12165: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
12166: IS
12167: SELECT amt.amount_type_code,
12168: amt_lu.meaning amount_type_name,

Line 12202: FROM pa_fp_proj_xl_amt_types amt,

12198: decode(l_proj_fp_options_rec.project_cost_rate_type,'User',null,l_proj_fp_options_rec.project_cost_rate_date_type)),'FIXED_DATE'))) project_rate_date_type,
12199:
12200: decode(amt.amount_type_code,'TOTAL_REV',decode(l_proj_fp_options_rec.project_rev_rate_date_type,'FIXED_DATE',l_proj_fp_options_rec.project_rev_rate_date,TO_DATE(null)),
12201: decode(l_proj_fp_options_rec.project_cost_rate_date_type,'FIXED_DATE',l_proj_fp_options_rec.project_cost_rate_date,TO_DATE(null))) project_rate_date
12202: FROM pa_fp_proj_xl_amt_types amt,
12203: pa_lookups amt_lu
12204: WHERE amt.project_id = c_project_id
12205: AND amt.fin_plan_type_id = c_fin_plan_type_id
12206: AND amt.option_type = c_option_type