APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_PROJ_XL_AMT_TYPES

Line 2508: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt

2504:
2505:
2506: UPDATE pa_fp_webadi_upload_inf inf
2507: SET amount_type_code = (SELECT pl.lookup_code
2508: FROM pa_lookups pl,pa_fp_proj_xl_amt_types xlt
2509: WHERE lookup_type=l_lookup_type
2510: AND meaning=inf.amount_type_name
2511: AND xlt.project_id=p_version_info_rec.x_project_id
2512: AND xlt.fin_plan_type_id=p_version_info_rec.x_fin_plan_type_id

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

11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
11926: l_proj_fp_options_rec proj_fp_options_rec;
11927:
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
11929: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
11930: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
11931: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
11932: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
11933: IS

Line 11930: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,

11926: l_proj_fp_options_rec proj_fp_options_rec;
11927:
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
11929: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
11930: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
11931: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
11932: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
11933: IS
11934: SELECT amt.amount_type_code,

Line 11931: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,

11927:
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
11929: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,
11930: c_fin_plan_type_id pa_fp_proj_xl_amt_types.fin_plan_type_id%TYPE,
11931: c_option_type pa_fp_proj_xl_amt_types.option_type%TYPE,
11932: c_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE)
11933: IS
11934: SELECT amt.amount_type_code,
11935: amt_lu.meaning amount_type_name,

Line 11969: FROM pa_fp_proj_xl_amt_types amt,

11965: 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,
11966:
11967: 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)),
11968: 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
11969: FROM pa_fp_proj_xl_amt_types amt,
11970: pa_lookups amt_lu
11971: WHERE amt.project_id = c_project_id
11972: AND amt.fin_plan_type_id = c_fin_plan_type_id
11973: AND amt.option_type = c_option_type