APPS.FV_BE_INT_PKG dependencies on FV_BUDGET_USER_DTL

Line 1291: FROM fv_budget_user_dtl

1287: -- Select the budget group id for the User
1288: BEGIN
1289: SELECT bu_group_id
1290: INTO l_bu_group_id
1291: FROM fv_budget_user_dtl
1292: WHERE set_of_books_id = valid_rec.set_of_books_id
1293: AND bu_user_id = valid_rec.budget_user_id
1294: AND valid_rec.budget_level_id BETWEEN bu_access_level_from AND bu_access_level_to;
1295: EXCEPTION

Line 1495: FROM fv_budget_user_dtl

1491:
1492: BEGIN
1493: SELECT bu_group_id
1494: INTO l_bu_group_id
1495: FROM fv_budget_user_dtl
1496: WHERE set_of_books_id = valid_rec.set_of_books_id
1497: AND bu_user_id = valid_rec.budget_user_id
1498: AND valid_rec.budget_level_id BETWEEN bu_access_level_from and bu_access_level_to;
1499: EXCEPTION

Line 1891: FROM fv_budget_user_dtl

1887: BEGIN
1888: l_module_name := g_module_name || 'validate_budget_user';
1889: SELECT COUNT(*)
1890: INTO l_count
1891: FROM fv_budget_user_dtl
1892: WHERE set_of_books_id = p_sob_id
1893: AND bu_user_id = p_bu_user_id;
1894: IF l_count = 0 THEN
1895: v_error_code := -10;

Line 1918: FROM fv_budget_user_dtl

1914: BEGIN
1915: l_module_name := g_module_name || 'validate_bu_access_level';
1916: SELECT NVL(bu_update_flag,'N')
1917: INTO l_update_flag
1918: FROM fv_budget_user_dtl
1919: WHERE set_of_books_id = p_sob_id
1920: AND bu_user_id = p_bu_user_id
1921: AND p_budget_level_id BETWEEN bu_access_level_from AND bu_access_level_to;
1922: IF l_update_flag ='N' THEN