APPS.GL_GLWACCTR_XMLP_PKG dependencies on GL_JE_CATEGORIES

Line 866: FROM GL_JE_CATEGORIES

862:
863: IF P_CATEGORY IS NOT NULL THEN
864: SELECT USER_JE_CATEGORY_NAME
865: INTO PARAM_CATEGORY
866: FROM GL_JE_CATEGORIES
867: WHERE JE_CATEGORY_NAME = P_CATEGORY;
868: END IF;
869:
870: PARAM_BATCH_NAME := P_BATCH_NAME;

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 985: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)

981: P_HINT_CLAUSE := '/*+ ORDERED USE_NL(LS) INDEX(LS GL_LEDGER_SET_ASSIGNMENTS_N1)
982: USE_NL(GLL) INDEX (GLL GL_JE_LINES_U1)
983: USE_NL(GLL)INDEX(CC GL_CODE_COMBINATIONS_U1)
984: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
985: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
986: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
987: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
988: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
989: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)

Line 996: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)

992: P_HINT_CLAUSE := '/*+ ORDERED
993: USE_NL(GLL) INDEX (GLL GL_JE_LINES_U1)
994: USE_NL(GLL)INDEX(CC GL_CODE_COMBINATIONS_U1)
995: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
996: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
997: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
998: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
999: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1000: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)

Line 1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||

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
1011: -- AND IN THIS CASE IT IS INCLUDED INTO THE P_PERF_FROM

Line 1027: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUNCES DOCSEQ, '||

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;
1030:
1031: