4: CURSOR LEDGER_ACCTG_CODE IS
5: SELECT
6: C.ACCTG_ENVIRONMENT_CODE
7: FROM
8: GL_LEDGERS L,
9: GL_LEDGER_CONFIGURATIONS C
10: WHERE L.LEDGER_ID = P_LEDGER_ID
11: AND C.CONFIGURATION_ID = L.CONFIGURATION_ID;
12: CURSOR GET_EXC_LE_ID IS
12: CURSOR GET_EXC_LE_ID IS
13: SELECT
14: CD.OBJECT_ID
15: FROM
16: GL_LEDGERS L,
17: GL_LEDGER_CONFIG_DETAILS CD
18: WHERE L.LEDGER_ID = P_LEDGER_ID
19: AND CD.CONFIGURATION_ID = L.CONFIGURATION_ID
20: AND CD.OBJECT_TYPE_CODE = 'LEGAL_ENTITY';
53: NVL(LR.TARGET_LEDGER_NAME
54: ,L.NAME)
55: INTO PARAM_LEDGER_NAME
56: FROM
57: GL_LEDGERS L,
58: GL_LEDGER_RELATIONSHIPS LR
59: WHERE L.LEDGER_ID = P_LEDGER_ID
60: AND LR.APPLICATION_ID (+) = 101
61: AND LR.SOURCE_LEDGER_ID (+) = L.LEDGER_ID