APPS.JG_JGZZGLJRN_XMLP_PKG dependencies on GL_LEDGERS

Line 52: GL_LEDGERS

48: SELECT
49: OBJECT_TYPE_CODE
50: INTO L_LEDGER_TYPE
51: FROM
52: GL_LEDGERS
53: WHERE LEDGER_ID = P_LEDGER_ID;
54: EXCEPTION
55: WHEN OTHERS THEN
56: T_ERRORBUFFER := SQLERRM;

Line 88: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,

84: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
85: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
86: */ ';
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

Line 109: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,

105: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
106: USE_NL(LS) INDEX(LS GL_LEDGER_SET_ASSIGNMENTS_N1)
107: */ ';
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;

Line 118: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,

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,
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

Line 145: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,

141: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
142: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
143: */ ';
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

Line 166: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,

162: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)
163: USE_NL(LS) INDEX(LS GL_LEDGER_SET_ASSIGNMENTS_N1)
164: */ ';
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;

Line 175: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,

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