DBA Data[Home] [Help]

APPS.JL_JGZZGLTRB_XMLP_PKG dependencies on GL_LEDGERS

Line 8: GL_LEDGERS L,

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

Line 16: GL_LEDGERS L,

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';

Line 57: GL_LEDGERS L,

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