DBA Data[Home] [Help]

APPS.JG_JGZZGLJRB_XMLP_PKG dependencies on GL_LEDGERS

Line 11: GL_LEDGERS L,

7: CURSOR LEDGER_ACCTG_CODE IS
8: SELECT
9: C.ACCTG_ENVIRONMENT_CODE
10: FROM
11: GL_LEDGERS L,
12: GL_LEDGER_CONFIGURATIONS C
13: WHERE L.LEDGER_ID = P_LEDGER_ID
14: AND C.CONFIGURATION_ID = L.CONFIGURATION_ID;
15: CURSOR GET_EXC_LE_ID IS

Line 19: GL_LEDGERS L,

15: CURSOR GET_EXC_LE_ID IS
16: SELECT
17: CD.OBJECT_ID
18: FROM
19: GL_LEDGERS L,
20: GL_LEDGER_CONFIG_DETAILS CD
21: WHERE L.LEDGER_ID = P_LEDGER_ID
22: AND CD.CONFIGURATION_ID = L.CONFIGURATION_ID
23: AND CD.OBJECT_TYPE_CODE = 'LEGAL_ENTITY';

Line 46: GL_LEDGERS

42: SELECT
43: NAME
44: INTO LEDGER_NAME_PARAM
45: FROM
46: GL_LEDGERS
47: WHERE LEDGER_ID = P_LEDGER_ID;
48: OPEN LEDGER_ACCTG_CODE;
49: FETCH LEDGER_ACCTG_CODE
50: INTO L_ACCTG_CODE;