APPS.IGC_LEDGER_UTILS dependencies on GL_LEDGERS

Line 89: l_primary_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;

85: -- To check Dual budgetary is enabled for either PO or CC
86: FUNCTION is_dual_bc_enabled
87: (p_ledger_id IN NUMBER
88: , p_ledger_category IN VARCHAR2) RETURN VARCHAR2 IS
89: l_primary_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;
90: CURSOR c_primary_ledger IS
91: SELECT primary_ledger_id
92: FROM GL_LEDGER_RELATIONSHIPS
93: WHERE target_ledger_category_code = 'SECONDARY'

Line 123: , GL_LEDGERS LED

119: CURSOR c_cbc_ledger IS
120: SELECT SEC.LEDGER_ID,
121: SEC.LEDGER_NAME
122: FROM GL_SECONDARY_LEDGER_RSHIPS_V SEC
123: , GL_LEDGERS LED
124: WHERE LED.LEDGER_ID = SEC.LEDGER_ID
125: AND LED.COMMITMENT_BUDGET_FLAG = 'Y'
126: AND SEC.PRIMARY_LEDGER_ID = p_primary_ledger_id;
127:

Line 129: l_sec_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;

125: AND LED.COMMITMENT_BUDGET_FLAG = 'Y'
126: AND SEC.PRIMARY_LEDGER_ID = p_primary_ledger_id;
127:
128: l_full_path VARCHAR2(500) := g_path||'get_cbc_ledger';
129: l_sec_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;
130: l_sec_ledger_name GL_LEDGERS.NAME%TYPE;
131:
132: BEGIN
133: OPEN c_cbc_ledger;

Line 130: l_sec_ledger_name GL_LEDGERS.NAME%TYPE;

126: AND SEC.PRIMARY_LEDGER_ID = p_primary_ledger_id;
127:
128: l_full_path VARCHAR2(500) := g_path||'get_cbc_ledger';
129: l_sec_ledger_id GL_LEDGERS.LEDGER_ID%TYPE;
130: l_sec_ledger_name GL_LEDGERS.NAME%TYPE;
131:
132: BEGIN
133: OPEN c_cbc_ledger;
134: FETCH c_cbc_ledger INTO l_sec_ledger_id, l_sec_ledger_name;