APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 405: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;

401: tmp_flag varchar2(1);
402: tmp_rlm_tab pa_plsql_datatypes.IdTabTyp;
403: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
404: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
405: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
406:
407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

Line 1406: FROM pa_resource_lists_all_bg

1402: --hr_utility.trace('target rl id:'||l_fp_cols_rec_target.X_resource_list_id);
1403: --hr_utility.trace('source rl id:'||l_fp_cols_rec_source.X_resource_list_id);
1404:
1405: SELECT NVL(UNCATEGORIZED_FLAG,'N') into l_uncategorized_flag
1406: FROM pa_resource_lists_all_bg
1407: WHERE resource_list_id = l_fp_cols_rec_target.X_resource_list_id;
1408:
1409: -- ER 4376722: Consolidated update of UOM and rate_based_flag for
1410: -- cost-based Revenue generation within the this API before any

Line 5675: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;

5671: IS
5672: l_module_name VARCHAR2(100) := 'PA.PLSQL.PA_FP_WP_GEN_BUDGET_AMT_PUB.'
5673: || 'GET_CALC_API_FLAG_PARAMS';
5674:
5675: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
5676: l_wp_track_cost_flag VARCHAR2(1);
5677:
5678: /* Time-phase determines if budget lines have been populated by generation code */
5679: l_same_time_phase_flag VARCHAR2(1);