DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on GL_ACCESS_SET_ASSIGNMENTS

Line 820: FROM GL_ACCESS_SET_ASSIGNMENTS asa

816: , 'ALC', rs.PRIMARY_LEDGER_ID
817: , rs.LEDGER_ID)) = v_ledger_id
818: AND rs.LEDGER_ID NOT IN
819: (SELECT asa.LEDGER_ID
820: FROM GL_ACCESS_SET_ASSIGNMENTS asa
821: WHERE asa.ACCESS_SET_ID
822: IN (g_access_set_id,
823: g_sec_access_set_id)));
824: EXCEPTION

Line 5290: FROM GL_ACCESS_SET_ASSIGNMENTS asa

5286: AND lgopt2.ENABLED_FLAG = 'Y'
5287: AND lgopt2.MERGE_ACCT_OPTION_CODE <> 'NONE'
5288: AND rs.LEDGER_ID NOT IN
5289: (SELECT asa.LEDGER_ID
5290: FROM GL_ACCESS_SET_ASSIGNMENTS asa
5291: WHERE asa.ACCESS_SET_ID
5292: IN (g_access_set_id, g_sec_access_set_id)))))
5293: ORDER BY evt.EVENT_DATE, evt.EVENT_ID;
5294: */

Line 5534: FROM GL_ACCESS_SET_ASSIGNMENTS asa

5530: AND lgopt2.ENABLED_FLAG = ''Y''
5531: AND lgopt2.MERGE_ACCT_OPTION_CODE <> ''NONE''
5532: AND rs.LEDGER_ID NOT IN
5533: (SELECT asa.LEDGER_ID
5534: FROM GL_ACCESS_SET_ASSIGNMENTS asa
5535: WHERE asa.ACCESS_SET_ID
5536: IN (''' || G_ACCESS_SET_ID || '''
5537: ,''' || G_SEC_ACCESS_SET_ID || ''')))))
5538: ORDER BY evt.EVENT_DATE, evt.EVENT_ID';