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 60: flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE

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

Line 981: FROM fnd_id_flex_segments_vl

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

Line 1014: l_segment_desc FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;

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

Line 1023: FROM fnd_id_flex_segments_vl

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