eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_BE_INT_PKG dependencies on FV_BUDGET_DISTRIBUTION_DTL

Line 626: ' FROM fv_budget_distribution_dtl

622:
623: l_stmt:=
624: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
625: app_col_name.application_column_name||
626: ' FROM fv_budget_distribution_dtl
627: WHERE set_of_books_id = :set_of_books_id
628: AND budget_level_id = :budget_level_id
629: AND fund_value = :fund_value ';
630:

Line 692: FROM fv_budget_distribution_dtl

688: := app_col_rec.flex_value_set_id;
689:
690: l_stmt:=
691: 'SELECT '||app_col_rec.application_column_name||'_TYPE
692: FROM fv_budget_distribution_dtl
693: WHERE set_of_books_id = :set_of_books_id
694: AND budget_level_id = :budget_level_id
695: AND fund_value = :fund_value ';
696:

Line 754: FROM fv_budget_distribution_dtl

750: l_seg_type := NULL;
751:
752: l_stmt:=
753: 'SELECT '||app_col_rec.application_column_name||'_TYPE
754: FROM fv_budget_distribution_dtl
755: WHERE set_of_books_id = :set_of_books_id
756: AND budget_level_id = :budget_level_id
757: AND fund_value = :fund_value ';
758:

Line 948: FROM fv_budget_distribution_dtl

944: l_seg_type := NULL;
945:
946: l_stmt:=
947: 'SELECT '||app_col_rec.application_column_name||'_TYPE
948: FROM fv_budget_distribution_dtl
949: WHERE set_of_books_id = :set_of_books_id
950: AND fund_value = :fund_value
951: AND budget_level_id =
952: (SELECT MAX(budget_level_id)

Line 953: FROM fv_budget_distribution_dtl

949: WHERE set_of_books_id = :set_of_books_id
950: AND fund_value = :fund_value
951: AND budget_level_id =
952: (SELECT MAX(budget_level_id)
953: FROM fv_budget_distribution_dtl
954: WHERE fund_value = :fund_value
955: AND set_of_books_id = :set_of_books_id
956: AND budget_level_id < :budget_level_id )';
957:

Line 986: ' FROM fv_budget_distribution_dtl

982: THEN
983:
984: l_stmt:=
985: 'SELECT '||app_col_rec.application_column_name||
986: ' FROM fv_budget_distribution_dtl
987: WHERE set_of_books_id = :set_of_books_id
988: AND fund_value = :fund_value
989: AND budget_level_id =
990: (SELECT MAX(budget_level_id)

Line 991: FROM fv_budget_distribution_dtl

987: WHERE set_of_books_id = :set_of_books_id
988: AND fund_value = :fund_value
989: AND budget_level_id =
990: (SELECT MAX(budget_level_id)
991: FROM fv_budget_distribution_dtl
992: WHERE fund_value = :fund_value
993: AND set_of_books_id = :set_of_books_id
994: AND budget_level_id < :budget_level_id )';
995:

Line 1188: ' FROM fv_budget_distribution_dtl

1184:
1185: l_stmt:=
1186: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
1187: app_col_name.application_column_name||
1188: ' FROM fv_budget_distribution_dtl
1189: WHERE set_of_books_id = :set_of_books_id
1190: AND budget_level_id = :budget_level_id
1191: AND fund_value = :fund_value ';
1192:

Line 1383: FROM fv_budget_distribution_dtl

1379: l_seg_type := NULL;
1380:
1381: l_stmt:=
1382: 'SELECT '||app_col_rec.application_column_name||'_TYPE
1383: FROM fv_budget_distribution_dtl
1384: WHERE set_of_books_id = :set_of_books_id
1385: AND fund_value = :fund_value
1386: AND budget_level_id =
1387: (SELECT MAX(budget_level_id)

Line 1388: FROM fv_budget_distribution_dtl

1384: WHERE set_of_books_id = :set_of_books_id
1385: AND fund_value = :fund_value
1386: AND budget_level_id =
1387: (SELECT MAX(budget_level_id)
1388: FROM fv_budget_distribution_dtl
1389: WHERE fund_value = :fund_value
1390: AND set_of_books_id = :set_of_books_id
1391: AND budget_level_id < :budget_level_id )';
1392:

Line 1407: ' FROM fv_budget_distribution_dtl

1403: THEN
1404:
1405: l_stmt:=
1406: 'SELECT '||app_col_rec.application_column_name||
1407: ' FROM fv_budget_distribution_dtl
1408: WHERE set_of_books_id = :set_of_books_id
1409: AND fund_value = :fund_value
1410: AND budget_level_id =
1411: (SELECT MAX(budget_level_id)

Line 1412: FROM fv_budget_distribution_dtl

1408: WHERE set_of_books_id = :set_of_books_id
1409: AND fund_value = :fund_value
1410: AND budget_level_id =
1411: (SELECT MAX(budget_level_id)
1412: FROM fv_budget_distribution_dtl
1413: WHERE fund_value = :fund_value
1414: AND set_of_books_id = :set_of_books_id
1415: AND budget_level_id < :budget_level_id )';
1416:

Line 1463: -- FROM fv_budget_distribution_dtl

1459: AND fbd.budgeting_segments = valid_rec.budgeting_segments
1460: AND rownum < 2
1461: AND fbh.budget_level_id =
1462: (SELECT MAX(budget_level_id)
1463: -- FROM fv_budget_distribution_dtl
1464: FROM fv_be_trx_dtls
1465: WHERE fund_value = valid_rec.fund_value
1466: AND set_of_books_id = valid_rec.set_of_books_id
1467: AND budget_level_id < valid_rec.budget_level_id

Line 1949: FROM fv_budget_distribution_dtl fbd

1945: BEGIN
1946: l_module_name := g_module_name || 'validate_fund_value';
1947: SELECT 'x'
1948: INTO v_exists
1949: FROM fv_budget_distribution_dtl fbd
1950: WHERE fbd.set_of_books_id = v_set_of_books_id
1951: AND fbd.fund_value = v_fund_value
1952: AND fbd.budget_level_id = v_budget_level_id;
1953: EXCEPTION

Line 2291: ' FROM fv_budget_distribution_dtl

2287:
2288: lv_stmt:=
2289: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
2290: app_col_name.application_column_name||
2291: ' FROM fv_budget_distribution_dtl
2292: WHERE set_of_books_id = :set_of_books_id
2293: AND budget_level_id = :budget_level_id
2294: AND fund_value = :fund_value ';
2295: