APPS.GL_GLWACCTR_XMLP_PKG dependencies on GL_LEDGERS

Line 134: FROM GL_LEDGERS

130: BEGIN
131: SELECT CURRENCY_CODE, OBJECT_TYPE_CODE
132: INTO L_LEDGER_CURR,
133: L_LEDGER_TYPE
134: FROM GL_LEDGERS
135: WHERE LEDGER_ID = P_LEDGER_ID;
136: EXCEPTION
137: WHEN OTHERS THEN
138: T_ERRORBUFFER := SQLERRM;

Line 716: ' GL_LEDGERS LGR1,

712: P_JOURNAL_FROM_CLAUSE:= ', (SELECT DISTINCT GLL2.JE_HEADER_ID JE_HEADER_ID,
713: GLL2.SUBLEDGER_DOC_SEQUENCE_ID SUB_DOC_SEQ_ID,
714: GLL2.SUBLEDGER_DOC_SEQUENCE_VALUE SUB_DOC_SEQ_VALUE
715: FROM ' || JOURNAL_FROM ||
716: ' GL_LEDGERS LGR1,
717: GL_JE_LINES GLL2,
718: GL_JE_HEADERS GLH2,
719: GL_CODE_COMBINATIONS GCC3 '||L_LEDGER_FROM||'
720: WHERE LGR1.LEDGER_ID = GLH2.LEDGER_ID

Line 831: FROM GL_LEDGERS

827:
828: IF P_LEDGER_ID IS NOT NULL THEN
829: SELECT NAME
830: INTO PARAM_LEDGER_NAME
831: FROM GL_LEDGERS
832: WHERE LEDGER_ID = P_LEDGER_ID;
833: END IF;
834:
835: IF P_STATUS IS NOT NULL THEN

Line 966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||

962: IF ((P_STATUS = 'E') OR (P_STATUS = 'U') OR (P_BATCH_NAME IS NOT NULL)) THEN
963:
964: P_PERF_FROM :=
965: ' GL_JE_BATCHES GLB, GL_JE_HEADERS GLH '||P_LEDGER_FROM||
966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||
967: ' GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;
969:
970: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE

Line 1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||

1002: END IF;
1003:
1004: P_PERF_FROM :=
1005: ' GL_JE_HEADERS GLH '||P_LEDGER_FROM||
1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||
1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';
1009:
1010: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE

Line 1025: ' GL_JE_HEADERS GLH, GL_LEDGERS LGR,'||P_LEDGER_FROM||

1021: ELSE
1022:
1023: P_HINT_CLAUSE := ' ';
1024: /* :P_PERF_FROM :=
1025: ' GL_JE_HEADERS GLH, GL_LEDGERS LGR,'||P_LEDGER_FROM||
1026: ' GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_BATCHES GLB, GL_JE_SOURCES GJS, '||
1027: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUNCES DOCSEQ, '||
1028: ' FND_DOCUMENT_SEQUNCES SUBDOCSEQ, FND_USER FU'; */
1029: END IF;