APPS.GL_GLWACCTR_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 483: P_JOURNAL_DATE_WHERE_2 := ' AND GLH2.PERIOD_NAME IN (SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES PS

479:
480: IF P_USE_DATE_COL = 'GLH2.DEFAULT_EFFECTIVE_DATE' AND
481: (P_START_DATE IS NOT NULL OR P_END_DATE IS NOT NULL) THEN
482: -- SUB QUERY START
483: P_JOURNAL_DATE_WHERE_2 := ' AND GLH2.PERIOD_NAME IN (SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES PS
484: WHERE PS.APPLICATION_ID = 101 AND PS.LEDGER_ID = LGR1.LEDGER_ID ';
485: /* BUGFIX - 3804059 AND 4043565 CHANGED VARIABLES TO BIND */
486: IF P_START_DATE IS NULL THEN
487: P_JOURNAL_DATE_WHERE_2 := P_JOURNAL_DATE_WHERE_2 ||' AND ( PS.START_DATE <= ''' || H_END_DATE || ''' )';

Line 500: P_JOURNAL_DATE_WHERE_2 := ' AND GLL2.PERIOD_NAME IN (SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES PS

496: ELSIF P_USE_DATE_COL = 'GLL2.EFFECTIVE_DATE' AND --:P_JOURNAL_DATE_WHERE_2 IS NOT NULL THEN
497: (P_START_DATE IS NOT NULL OR P_END_DATE IS NOT NULL) THEN
498:
499: -- SUB QUERY START
500: P_JOURNAL_DATE_WHERE_2 := ' AND GLL2.PERIOD_NAME IN (SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES PS
501: WHERE PS.APPLICATION_ID = 101 AND PS.SET_OF_BOOKS_ID = ' || P_LEDGER_ID || ' ';
502: -- BUGFIX - 3804059 AND 4043565 CHANGED VARIABLES TO BIND
503: IF P_START_DATE IS NULL THEN
504: P_JOURNAL_DATE_WHERE_2 := P_JOURNAL_DATE_WHERE_2 ||' AND ( PS.START_DATE <= ''' || H_END_DATE || ''' )';

Line 573: FROM GL_PERIOD_STATUSES PS

569: (P_START_DATE IS NOT NULL OR P_END_DATE IS NOT NULL) THEN
570:
571: /* -- SUB QUERY START
572: :P_JOURNAL_DATE_WHERE := ' AND GLH.PERIOD_NAME IN (SELECT + CARDINALITY(PS,2 ) PERIOD_NAME
573: FROM GL_PERIOD_STATUSES PS
574: WHERE PS.APPLICATION_ID = 101 AND PS.LEDGER_ID = LGR.LEDGER_ID ';
575: */
576: -- BUGFIX - 3804059 AND 4043565 CHANGES VARIABLES TO BIND
577: IF P_START_DATE IS NULL THEN

Line 592: FROM GL_PERIOD_STATUSES PS

588: (P_START_DATE IS NOT NULL OR P_END_DATE IS NOT NULL) THEN
589:
590: -- SUB QUERY START
591: P_JOURNAL_DATE_WHERE := ' AND GLL.PERIOD_NAME IN (SELECT /*+ CARDINAILTY(PS,2 ) */ PERIOD_NAME
592: FROM GL_PERIOD_STATUSES PS
593: WHERE PS.APPLICATION_ID = 101 AND PS.LEDGER_ID = LGR.LEDGER_ID ';
594:
595: -- BUGFIX - 3804059 AND 4043565 CHANGES VARIABLES TO BIND
596: IF P_START_DATE IS NULL THEN

Line 1085: FROM gl_period_statuses

1081: EXCEPTION
1082: WHEN NO_DATA_FOUND THEN
1083: SELECT MIN(start_date)
1084: INTO start_period_date
1085: FROM gl_period_statuses
1086: WHERE application_id = 101
1087: AND set_of_books_id = H_SET_OF_BOOKS_ID
1088: AND adjustment_period_flag <> 'Y';
1089:

Line 1112: FROM gl_period_statuses p1

1108: EXCEPTION
1109: WHEN NO_DATA_FOUND THEN
1110: SELECT p1.period_name
1111: INTO start_period_name
1112: FROM gl_period_statuses p1
1113: WHERE p1.application_id = 101
1114: AND p1.set_of_books_id = H_SET_OF_BOOKS_ID
1115: AND p1.adjustment_period_flag <> 'Y'
1116: AND p1.start_date =

Line 1118: FROM gl_period_statuses p2

1114: AND p1.set_of_books_id = H_SET_OF_BOOKS_ID
1115: AND p1.adjustment_period_flag <> 'Y'
1116: AND p1.start_date =
1117: (SELECT MIN(p2.start_date)
1118: FROM gl_period_statuses p2
1119: WHERE p2.application_id = p1.application_id
1120: AND p2.set_of_books_id = p1.set_of_books_id
1121: AND p2.adjustment_period_flag <> 'Y');
1122: