DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 41: gl_ledgers_public_v gsb

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

Line 704: FROM gl_ledgers_public_v

700:
701: -- get chart of accounts id
702: SELECT chart_of_accounts_id
703: INTO v_coa_id
704: FROM gl_ledgers_public_v
705: WHERE ledger_id = int_rec.set_of_books_id;
706:
707: --------------------------------------------------------------------------------
708: -- Validate mandatory segments. Check if the segment values,

Line 943: gl_ledgers_public_v gsb

939: BEGIN
940: SELECT concatenated_segment_delimiter
941: INTO v_delimiter
942: FROM fnd_id_flex_structures ffs,
943: gl_ledgers_public_v gsb
944: WHERE application_id = 101
945: AND id_flex_code = 'GL#'
946: AND ffs.id_flex_num = gsb.chart_of_accounts_id
947: AND gsb.ledger_id = int_rec.set_of_books_id;

Line 1429: gl_ledgers_public_v gsb

1425:
1426: SELECT concatenated_segment_delimiter
1427: INTO v_delimiter
1428: FROM fnd_id_flex_structures ffs,
1429: gl_ledgers_public_v gsb
1430: WHERE application_id = 101
1431: AND id_flex_code = 'GL#'
1432: AND ffs.id_flex_num = gsb.chart_of_accounts_id
1433: AND gsb.ledger_id = valid_rec.set_of_books_id;

Line 1903: FROM gl_ledgers_public_v

1899: BEGIN
1900: l_module_name := g_module_name || 'validate_sob';
1901: SELECT 'x'
1902: INTO v_exists
1903: FROM gl_ledgers_public_v
1904: WHERE ledger_id = v_sob_id;
1905: EXCEPTION
1906: WHEN NO_DATA_FOUND THEN
1907: v_error_code := -9;

Line 2438: gl_ledgers_public_v gsb

2434: l_module_name := g_module_name || 'concat_segs';
2435: SELECT concatenated_segment_delimiter
2436: INTO l_delmtr
2437: FROM fnd_id_flex_structures ffs,
2438: gl_ledgers_public_v gsb
2439: WHERE application_id = 101
2440: AND id_flex_code = 'GL#'
2441: AND ffs.id_flex_num = gsb.chart_of_accounts_id
2442: AND gsb.ledger_id = l_sob_id;