APPS.JE_IT_EXEMPT_LETTERS_PKG dependencies on GL_ALC_LEDGER_RSHIPS_V

Line 31: FROM gl_alc_ledger_rships_v

27: AND effective_to = X_Effective_To;
28:
29: CURSOR c_alc_ledger (p_ledger_id IN NUMBER) IS
30: SELECT ledger_id, currency_code
31: FROM gl_alc_ledger_rships_v
32: WHERE primary_ledger_id = p_ledger_id
33: AND application_id = 222
34: AND org_id = MO_GLOBAL.get_current_org_id
35: -- AND nvl(org_id,-99) = NVL(NVL(rtrim(substr(userenv('CLIENT_INFO'),1,10)),-99),-99)

Line 230: FROM gl_alc_ledger_rships_v

226: X_Created_By NUMBER
227: ) IS
228: CURSOR c_alc_ledger (p_ledger_id in number) is
229: SELECT ledger_id, currency_code
230: FROM gl_alc_ledger_rships_v
231: WHERE primary_ledger_id = p_ledger_id
232: AND application_id = 222
233: AND org_id = MO_GLOBAL.get_current_org_id
234: -- AND NVL(org_id,-99) = NVL(NVL(rtrim(substr(userenv('CLIENT_INFO'),1,10)),-99), -99)

Line 316: FROM gl_alc_ledger_rships_v

312: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
313:
314: CURSOR c_alc_ledger (p_ledger_id in number) is
315: SELECT ledger_id, currency_code
316: FROM gl_alc_ledger_rships_v
317: WHERE primary_ledger_id = p_ledger_id
318: AND application_id = 222
319: AND org_id = MO_GLOBAL.get_current_org_id
320: -- AND NVL(org_id,-99) = NVL(NVL(rtrim(substr(userenv('CLIENT_INFO'),1,10)),-99), -99)