APPS.OKL_ACCOUNTING_UTIL dependencies on FND_ID_FLEX_SEGMENTS_VL

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