APPS.FV_TBAL_BY_TS dependencies on GL_LEDGERS_PUBLIC_V

Line 30: SELECT name, chart_of_accounts_id FROM gl_ledgers_public_v

26: IS
27:
28: CURSOR Cur_ledger
29: IS
30: SELECT name, chart_of_accounts_id FROM gl_ledgers_public_v
31: WHERE ledger_id = p_ledger_id;
32:
33: CURSOR Cur_seg_name (p_chart_of_accounts_id number, p_attribute_type varchar2)
34: IS

Line 58: v_ledger_name gl_ledgers_public_v.name%TYPE;

54: AND segment_attribute_type = p_attribute_type
55: AND attribute_value = 'Y';
56:
57: l_module_name VARCHAR2(200) := g_module_name || 'main';
58: v_ledger_name gl_ledgers_public_v.name%TYPE;
59: v_chart_of_accounts_id NUMBER;
60: v_acc_seg_name VARCHAR2(25);
61: v_bal_seg_name VARCHAR2(25);
62: v_statement VARCHAR2(32767);