APPS.OKL_ACCOUNTING_UTIL dependencies on FND_ID_FLEX_SEGMENTS

Line 40: FROM fnd_id_flex_segments

36: AS
37: CURSOR flex_segment_csr
38: IS
39: SELECT flex_value_set_id
40: FROM fnd_id_flex_segments
41: WHERE id_flex_num = p_chart_of_account_id
42: AND application_id = 101
43: AND id_flex_code = 'GL#'
44: AND enabled_flag = 'Y'

Line 61: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE

57: -- Fixed Bug Number 3628755
58:
59: TYPE segment_rec_type IS RECORD
60: (segment_value fnd_flex_values_vl.flex_value%TYPE,
61: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE
62: );
63:
64: TYPE segment_table_type IS TABLE OF segment_rec_type INDEX BY BINARY_INTEGER;
65:

Line 982: FROM fnd_id_flex_segments_vl

978: CURSOR seg_csr (l_chart_of_accounts_id NUMBER) IS
979: SELECT segment_num,
980: application_column_name,
981: form_left_prompt
982: FROM fnd_id_flex_segments_vl
983: WHERE application_id = 101
984: AND id_flex_code = 'GL#'
985: AND enabled_flag = 'Y'
986: AND id_flex_num = l_chart_of_accounts_id;

Line 1015: l_segment_desc FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;

1011: RETURN VARCHAR2
1012: AS
1013:
1014: l_chart_of_accounts_id NUMBER;
1015: l_segment_desc FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
1016:
1017: CURSOR coa_csr(p_ledger_id IN NUMBER) IS
1018: SELECT chart_of_accounts_id
1019: FROM GL_LEDGERS_PUBLIC_V

Line 1024: FROM fnd_id_flex_segments_vl

1020: WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);
1021:
1022: CURSOR seg_csr (l_chart_of_accounts_id NUMBER) IS
1023: SELECT form_left_prompt
1024: FROM fnd_id_flex_segments_vl
1025: WHERE application_id = 101
1026: AND id_flex_code = 'GL#'
1027: AND enabled_flag = 'Y'
1028: AND id_flex_num = l_chart_of_accounts_id