APPS.JG_JGZZGLJRN_XMLP_PKG dependencies on GL_JE_CATEGORIES

Line 91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';

87: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
88: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
89: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
90: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
92: ELSE
93: P_PERIOD_INX_HINT := ' /*+ ORDERED
94: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
95: INDEX (CC GL_CODE_COMBINATIONS_N3)

Line 112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

108: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
109: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
110: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
111: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
113: END IF;
114: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
115: P_PERIOD_INX_HINT := '/*+ ORDERED */';
116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,

Line 120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
117: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
118: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
119: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
121: END IF;
122: ELSE
123: F_PERIOD_NUM := GET_EFF_PERIOD_NUM(P_ACCESS_SET_ID
124: ,P_PERIOD_FROM);

Line 148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';

144: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
145: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
146: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
147: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
149: ELSE
150: P_PERIOD_INX_HINT := ' /*+ ORDERED
151: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
152: INDEX (CC GL_CODE_COMBINATIONS_N3)

Line 169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

165: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
166: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
167: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
168: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
170: END IF;
171: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
172: P_PERIOD_INX_HINT := '/*+ ORDERED */';
173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,

Line 177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;

173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
174: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
175: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
176: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
178: END IF;
179: END IF;
180: IF ((P_START_DATE IS NOT NULL) OR (P_END_DATE IS NOT NULL)) THEN
181: IF (P_START_DATE = P_END_DATE) THEN

Line 311: GL_JE_CATEGORIES

307: SELECT
308: USER_JE_CATEGORY_NAME
309: INTO JRNL_CATEGORY_PARAM
310: FROM
311: GL_JE_CATEGORIES
312: WHERE JE_CATEGORY_NAME = P_CATEGORY;
313: END IF;
314: BATCH_NAME_PARAM := P_BATCH_NAME;
315: IF P_DOC_SEQ_NAME IS NOT NULL THEN