APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_RESOURCE_LISTS

Line 1339: FROM pa_resource_lists_all_bg

1335: BEGIN
1336:
1337: SELECT NVL(UNCATEGORIZED_FLAG,'N')
1338: INTO x_rl_uncategorized_flag
1339: FROM pa_resource_lists_all_bg
1340: WHERE resource_list_id = p_resource_list_id;
1341:
1342: RETURN x_rl_uncategorized_flag;
1343:

Line 1379: FROM pa_resource_lists_all_bg

1375: x_rlm_id NUMBER;
1376: BEGIN
1377: SELECT NVL(control_flag,'N')
1378: INTO l_control_flag
1379: FROM pa_resource_lists_all_bg
1380: WHERE resource_list_id = P_RESOURCE_LIST_ID;
1381:
1382: IF l_control_flag = 'Y' THEN
1383: select resource_list_member_id

Line 1498: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;

1494: -- logic for the source version id. This flag is only relevant
1495: -- if the Target is a Budget.
1496: l_default_bdgt_src_ver_flag VARCHAR2(1);
1497:
1498: l_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
1499:
1500: l_dummy NUMBER;
1501:
1502: l_msg_count NUMBER;

Line 1760: FROM pa_resource_lists

1756: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
1757: BEGIN
1758: SELECT nvl(UNCATEGORIZED_FLAG,'N')
1759: INTO l_uncategorized_flag
1760: FROM pa_resource_lists
1761: WHERE resource_list_id = l_fp_cols_rec_tgt.X_RESOURCE_LIST_ID;
1762: EXCEPTION
1763: WHEN NO_DATA_FOUND THEN
1764: l_uncategorized_flag := 'N';

Line 2706: pa_resource_lists_all_bg res

2702: BEGIN
2703: SELECT NVL(res.RESOURCE_CLASS_FLAG,'Y')
2704: INTO l_flag
2705: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT,
2706: pa_resource_lists_all_bg res
2707: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2708: AND OPT.PROJECT_ID = BV.PROJECT_ID
2709: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
2710: AND OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 2755: FROM pa_resource_lists_all_bg

2751: l_flag VARCHAR2(5) := NULL;
2752: BEGIN
2753: SELECT NVL(RESOURCE_CLASS_FLAG,'Y')
2754: INTO l_flag
2755: FROM pa_resource_lists_all_bg
2756: WHERE resource_list_id = P_RESOURCE_LIST_ID;
2757: RETURN l_flag;
2758: EXCEPTION
2759: WHEN OTHERS THEN