APPS.FV_BE_INT_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 40: gl_ledgers_public_v gsb

36:
37: CURSOR app_col(v_sob_id IN NUMBER) IS
38: SELECT application_column_name,flex_value_set_id
39: FROM fnd_id_flex_segments ffs,
40: gl_ledgers_public_v gsb
41: WHERE ffs.application_id = 101
42: AND ffs.id_flex_code = 'GL#'
43: AND ffs.id_flex_num = gsb.chart_of_accounts_id
44: AND gsb.ledger_id = v_sob_id

Line 671: FROM gl_ledgers_public_v

667:
668: -- get chart of accounts id
669: SELECT chart_of_accounts_id
670: INTO v_coa_id
671: FROM gl_ledgers_public_v
672: WHERE ledger_id = int_rec.set_of_books_id;
673:
674: --------------------------------------------------------------------------------
675: -- Validate mandatory segments. Check if the segment values,

Line 895: gl_ledgers_public_v gsb

891: BEGIN
892: SELECT concatenated_segment_delimiter
893: INTO v_delimiter
894: FROM fnd_id_flex_structures ffs,
895: gl_ledgers_public_v gsb
896: WHERE application_id = 101
897: AND id_flex_code = 'GL#'
898: AND ffs.id_flex_num = gsb.chart_of_accounts_id
899: AND gsb.ledger_id = int_rec.set_of_books_id;

Line 1355: gl_ledgers_public_v gsb

1351:
1352: SELECT concatenated_segment_delimiter
1353: INTO v_delimiter
1354: FROM fnd_id_flex_structures ffs,
1355: gl_ledgers_public_v gsb
1356: WHERE application_id = 101
1357: AND id_flex_code = 'GL#'
1358: AND ffs.id_flex_num = gsb.chart_of_accounts_id
1359: AND gsb.ledger_id = valid_rec.set_of_books_id;

Line 1816: FROM gl_ledgers_public_v

1812: BEGIN
1813: l_module_name := g_module_name || 'validate_sob';
1814: SELECT 'x'
1815: INTO v_exists
1816: FROM gl_ledgers_public_v
1817: WHERE ledger_id = v_sob_id;
1818: EXCEPTION
1819: WHEN NO_DATA_FOUND THEN
1820: v_error_code := -9;

Line 2347: gl_ledgers_public_v gsb

2343: l_module_name := g_module_name || 'concat_segs';
2344: SELECT concatenated_segment_delimiter
2345: INTO l_delmtr
2346: FROM fnd_id_flex_structures ffs,
2347: gl_ledgers_public_v gsb
2348: WHERE application_id = 101
2349: AND id_flex_code = 'GL#'
2350: AND ffs.id_flex_num = gsb.chart_of_accounts_id
2351: AND gsb.ledger_id = l_sob_id;