APPS.GL_GLWACCTR_XMLP_PKG dependencies on FND_USER

Line 875: FROM FND_USER

871:
872: IF P_LAST_UPDATED_BY IS NOT NULL THEN
873: SELECT USER_NAME
874: INTO PARAM_LAST_UPDATED_BY
875: FROM FND_USER
876: WHERE USER_ID = P_LAST_UPDATED_BY;
877: END IF;
878:
879: PARAM_BALANCING_SEGMENT := P_BAL_SEG_VAL;

Line 968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;

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

Line 990: USE_NL(FU) INDEX(FU FND_USER_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)
990: USE_NL(FU) INDEX(FU FND_USER_U1) */';
991: ELSE
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)

Line 1001: USE_NL(FU) INDEX(FU FND_USER_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)
1001: USE_NL(FU) INDEX(FU FND_USER_U1) */';
1002: END IF;
1003:
1004: P_PERF_FROM :=
1005: ' GL_JE_HEADERS GLH '||P_LEDGER_FROM||

Line 1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';

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
1012:

Line 1028: ' FND_DOCUMENT_SEQUNCES SUBDOCSEQ, FND_USER FU'; */

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:
1032: /******** END PERFORMANCE HINTS ********/