APPS.JE_IT_EXEMPT_LETTERS_PKG dependencies on MO_GLOBAL

Line 34: AND org_id = MO_GLOBAL.get_current_org_id

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)
36: AND relationship_enabled_flag = 'Y';
37:
38: BEGIN

Line 233: AND org_id = MO_GLOBAL.get_current_org_id

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)
235: AND relationship_enabled_flag = 'Y' ;
236:
237: BEGIN

Line 319: AND org_id = MO_GLOBAL.get_current_org_id

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)
321: AND relationship_enabled_flag = 'Y' ;
322:
323: