APPS.OKL_ACCOUNTING_UTIL dependencies on FND_ID_FLEX_SEGMENTS_VL

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