APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 370: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;

366: tmp_flag varchar2(1);
367: tmp_rlm_tab pa_plsql_datatypes.IdTabTyp;
368: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
369: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
370: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
371:
372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

Line 1364: FROM pa_resource_lists_all_bg

1360: --hr_utility.trace('target rl id:'||l_fp_cols_rec_target.X_resource_list_id);
1361: --hr_utility.trace('source rl id:'||l_fp_cols_rec_source.X_resource_list_id);
1362:
1363: SELECT NVL(UNCATEGORIZED_FLAG,'N') into l_uncategorized_flag
1364: FROM pa_resource_lists_all_bg
1365: WHERE resource_list_id = l_fp_cols_rec_target.X_resource_list_id;
1366:
1367: -- ER 4376722: Consolidated update of UOM and rate_based_flag for
1368: -- cost-based Revenue generation within the this API before any

Line 5596: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;

5592: IS
5593: l_module_name VARCHAR2(100) := 'PA.PLSQL.PA_FP_WP_GEN_BUDGET_AMT_PUB.'
5594: || 'GET_CALC_API_FLAG_PARAMS';
5595:
5596: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
5597: l_wp_track_cost_flag VARCHAR2(1);
5598:
5599: /* Time-phase determines if budget lines have been populated by generation code */
5600: l_same_time_phase_flag VARCHAR2(1);