APPS.FV_BE_INT_PKG dependencies on FV_BUDGET_USER_DTL

Line 1363: FROM fv_budget_user_dtl

1359: -- Select the budget group id for the User
1360: BEGIN
1361: SELECT bu_group_id
1362: INTO l_bu_group_id
1363: FROM fv_budget_user_dtl
1364: WHERE set_of_books_id = valid_rec.set_of_books_id
1365: AND bu_user_id = valid_rec.budget_user_id
1366: AND valid_rec.budget_level_id BETWEEN bu_access_level_from AND bu_access_level_to;
1367: EXCEPTION

Line 1575: FROM fv_budget_user_dtl

1571:
1572: BEGIN
1573: SELECT bu_group_id
1574: INTO l_bu_group_id
1575: FROM fv_budget_user_dtl
1576: WHERE set_of_books_id = valid_rec.set_of_books_id
1577: AND bu_user_id = valid_rec.budget_user_id
1578: AND valid_rec.budget_level_id BETWEEN bu_access_level_from and bu_access_level_to;
1579: EXCEPTION

Line 1978: FROM fv_budget_user_dtl

1974: BEGIN
1975: l_module_name := g_module_name || 'validate_budget_user';
1976: SELECT COUNT(*)
1977: INTO l_count
1978: FROM fv_budget_user_dtl
1979: WHERE set_of_books_id = p_sob_id
1980: AND bu_user_id = p_bu_user_id;
1981: IF l_count = 0 THEN
1982: v_error_code := -10;

Line 2005: FROM fv_budget_user_dtl

2001: BEGIN
2002: l_module_name := g_module_name || 'validate_bu_access_level';
2003: SELECT NVL(bu_update_flag,'N')
2004: INTO l_update_flag
2005: FROM fv_budget_user_dtl
2006: WHERE set_of_books_id = p_sob_id
2007: AND bu_user_id = p_bu_user_id
2008: AND p_budget_level_id BETWEEN bu_access_level_from AND bu_access_level_to;
2009: IF l_update_flag ='N' THEN