APPS.FA_RSVLDG_REP_INS_PKG dependencies on FA_DEPRN_DETAIL

Line 171: Index(DD_BONUS FA_DEPRN_DETAIL_U1)

167: BONUS_RATE ,
168: ASSET_COST_ACCT
169: )
170: SELECT /*+ ORDERED
171: Index(DD_BONUS FA_DEPRN_DETAIL_U1)
172: index(DH FA_DISTRIBUTION_HISTORY_U1)
173: Index(AH FA_ASSET_HISTORY_N2)
174: */
175: DH.ASSET_ID ASSET_ID ,

Line 196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

192: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
193: BR.BONUS_RATE ,
194: CB.ASSET_COST_ACCT
195: FROM
196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
198: MAX(PERIOD_COUNTER) PERIOD_COUNTER
199: FROM FA_DEPRN_DETAIL_MRC_V
200: WHERE BOOK_TYPE_CODE = book

Line 197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

193: BR.BONUS_RATE ,
194: CB.ASSET_COST_ACCT
195: FROM
196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
198: MAX(PERIOD_COUNTER) PERIOD_COUNTER
199: FROM FA_DEPRN_DETAIL_MRC_V
200: WHERE BOOK_TYPE_CODE = book
201: AND PERIOD_COUNTER <= upc

Line 199: FROM FA_DEPRN_DETAIL_MRC_V

195: FROM
196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
198: MAX(PERIOD_COUNTER) PERIOD_COUNTER
199: FROM FA_DEPRN_DETAIL_MRC_V
200: WHERE BOOK_TYPE_CODE = book
201: AND PERIOD_COUNTER <= upc
202: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
203: GROUP BY DISTRIBUTION_ID

Line 205: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

201: AND PERIOD_COUNTER <= upc
202: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
203: GROUP BY DISTRIBUTION_ID
204: ) dd1,
205: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
206: FA_DISTRIBUTION_HISTORY DH ,
207: FA_ASSET_HISTORY AH ,
208: FA_BOOKS_MRC_V BOOKS ,
209: FA_TRANSACTION_HEADERS TH_RT,

Line 247: Index(DD FA_DEPRN_DETAIL_U1)

243: AND DH.DATE_EFFECTIVE <= ucd
244: AND NVL(DH.DATE_INEFFECTIVE, sysdate) > tod
245: UNION ALL
246: SELECT /*+ ORDERED
247: Index(DD FA_DEPRN_DETAIL_U1)
248: index(DH FA_DISTRIBUTION_HISTORY_U1)
249: Index(AH FA_ASSET_HISTORY_N2)
250: */
251: DH.ASSET_ID ASSET_ID ,

Line 272: --FA_DEPRN_DETAIL_MRC_V DD,

268: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
269: BR.BONUS_RATE ,
270: CB.ASSET_COST_ACCT
271: FROM
272: --FA_DEPRN_DETAIL_MRC_V DD,
273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
274: MAX(PERIOD_COUNTER) PERIOD_COUNTER
275: FROM FA_DEPRN_DETAIL_MRC_V
276: WHERE BOOK_TYPE_CODE = book

Line 273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

269: BR.BONUS_RATE ,
270: CB.ASSET_COST_ACCT
271: FROM
272: --FA_DEPRN_DETAIL_MRC_V DD,
273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
274: MAX(PERIOD_COUNTER) PERIOD_COUNTER
275: FROM FA_DEPRN_DETAIL_MRC_V
276: WHERE BOOK_TYPE_CODE = book
277: AND PERIOD_COUNTER <= upc

Line 275: FROM FA_DEPRN_DETAIL_MRC_V

271: FROM
272: --FA_DEPRN_DETAIL_MRC_V DD,
273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
274: MAX(PERIOD_COUNTER) PERIOD_COUNTER
275: FROM FA_DEPRN_DETAIL_MRC_V
276: WHERE BOOK_TYPE_CODE = book
277: AND PERIOD_COUNTER <= upc
278: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
279: GROUP BY DISTRIBUTION_ID

Line 281: FA_DEPRN_DETAIL_MRC_V DD,

277: AND PERIOD_COUNTER <= upc
278: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
279: GROUP BY DISTRIBUTION_ID
280: ) dd1,
281: FA_DEPRN_DETAIL_MRC_V DD,
282: FA_DISTRIBUTION_HISTORY DH ,
283: FA_ASSET_HISTORY AH ,
284: FA_BOOKS_MRC_V BOOKS ,
285: FA_TRANSACTION_HEADERS TH_RT,

Line 347: Index(DD_BONUS FA_DEPRN_DETAIL_U1)

343: BONUS_RATE ,
344: ASSET_COST_ACCT
345: )
346: SELECT /*+ ORDERED
347: Index(DD_BONUS FA_DEPRN_DETAIL_U1)
348: index(DH FA_DISTRIBUTION_HISTORY_U1)
349: Index(AH FA_ASSET_HISTORY_N2)
350: */
351: DH.ASSET_ID ASSET_ID ,

Line 372: --FA_DEPRN_DETAIL DD_BONUS,

368: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
369: BR.BONUS_RATE ,
370: CB.ASSET_COST_ACCT
371: FROM
372: --FA_DEPRN_DETAIL DD_BONUS,
373: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
374: MAX(PERIOD_COUNTER) PERIOD_COUNTER
375: FROM FA_DEPRN_DETAIL
376: WHERE BOOK_TYPE_CODE = book

Line 373: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

369: BR.BONUS_RATE ,
370: CB.ASSET_COST_ACCT
371: FROM
372: --FA_DEPRN_DETAIL DD_BONUS,
373: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
374: MAX(PERIOD_COUNTER) PERIOD_COUNTER
375: FROM FA_DEPRN_DETAIL
376: WHERE BOOK_TYPE_CODE = book
377: AND PERIOD_COUNTER <= upc

Line 375: FROM FA_DEPRN_DETAIL

371: FROM
372: --FA_DEPRN_DETAIL DD_BONUS,
373: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
374: MAX(PERIOD_COUNTER) PERIOD_COUNTER
375: FROM FA_DEPRN_DETAIL
376: WHERE BOOK_TYPE_CODE = book
377: AND PERIOD_COUNTER <= upc
378: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
379: GROUP BY DISTRIBUTION_ID

Line 381: FA_DEPRN_DETAIL DD_BONUS ,

377: AND PERIOD_COUNTER <= upc
378: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
379: GROUP BY DISTRIBUTION_ID
380: ) DD1 ,
381: FA_DEPRN_DETAIL DD_BONUS ,
382: FA_DISTRIBUTION_HISTORY DH ,
383: FA_ASSET_HISTORY AH ,
384: FA_BOOKS BOOKS ,
385: FA_TRANSACTION_HEADERS TH_RT,

Line 423: Index(DD FA_DEPRN_DETAIL_U1)

419: null, DP.FISCAL_YEAR,
420: NVL(BR.END_YEAR, DP.FISCAL_YEAR))
421: UNION ALL
422: SELECT /*+ ORDERED
423: Index(DD FA_DEPRN_DETAIL_U1)
424: index(DH FA_DISTRIBUTION_HISTORY_U1)
425: Index(AH FA_ASSET_HISTORY_N2)
426: */
427: DH.ASSET_ID ASSET_ID ,

Line 448: --FA_DEPRN_DETAIL DD,

444: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
445: BR.BONUS_RATE ,
446: CB.ASSET_COST_ACCT
447: FROM
448: --FA_DEPRN_DETAIL DD,
449: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
450: MAX(PERIOD_COUNTER) PERIOD_COUNTER
451: FROM FA_DEPRN_DETAIL
452: WHERE BOOK_TYPE_CODE = book

Line 449: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

445: BR.BONUS_RATE ,
446: CB.ASSET_COST_ACCT
447: FROM
448: --FA_DEPRN_DETAIL DD,
449: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
450: MAX(PERIOD_COUNTER) PERIOD_COUNTER
451: FROM FA_DEPRN_DETAIL
452: WHERE BOOK_TYPE_CODE = book
453: AND PERIOD_COUNTER <= upc

Line 451: FROM FA_DEPRN_DETAIL

447: FROM
448: --FA_DEPRN_DETAIL DD,
449: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
450: MAX(PERIOD_COUNTER) PERIOD_COUNTER
451: FROM FA_DEPRN_DETAIL
452: WHERE BOOK_TYPE_CODE = book
453: AND PERIOD_COUNTER <= upc
454: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
455: GROUP BY DISTRIBUTION_ID

Line 457: FA_DEPRN_DETAIL DD ,

453: AND PERIOD_COUNTER <= upc
454: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
455: GROUP BY DISTRIBUTION_ID
456: ) DD1,
457: FA_DEPRN_DETAIL DD ,
458: FA_DISTRIBUTION_HISTORY DH ,
459: FA_ASSET_HISTORY AH ,
460: FA_BOOKS BOOKS ,
461: FA_TRANSACTION_HEADERS TH_RT,

Line 546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

542: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
543: BR.BONUS_RATE ,
544: CB.ASSET_COST_ACCT
545: FROM
546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
547: ( SELECT
548: DISTRIBUTION_ID ,
549: MAX(PERIOD_COUNTER) PERIOD_COUNTER
550: FROM FA_DEPRN_DETAIL_MRC_V

Line 550: FROM FA_DEPRN_DETAIL_MRC_V

546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
547: ( SELECT
548: DISTRIBUTION_ID ,
549: MAX(PERIOD_COUNTER) PERIOD_COUNTER
550: FROM FA_DEPRN_DETAIL_MRC_V
551: WHERE BOOK_TYPE_CODE = book
552: AND PERIOD_COUNTER <= upc
553: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
554: GROUP BY DISTRIBUTION_ID

Line 556: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

552: AND PERIOD_COUNTER <= upc
553: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
554: GROUP BY DISTRIBUTION_ID
555: ) dd1,
556: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
557: FA_DISTRIBUTION_HISTORY DH ,
558: FA_ASSET_HISTORY AH ,
559: FA_BOOKS_MRC_V BOOKS ,
560: FA_TRANSACTION_HEADERS TH_RT,

Line 647: --FA_DEPRN_DETAIL DD_BONUS,

643: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
644: BR.BONUS_RATE ,
645: CB.ASSET_COST_ACCT
646: FROM
647: --FA_DEPRN_DETAIL DD_BONUS,
648: ( SELECT
649: DISTRIBUTION_ID ,
650: MAX(PERIOD_COUNTER) PERIOD_COUNTER
651: FROM FA_DEPRN_DETAIL

Line 651: FROM FA_DEPRN_DETAIL

647: --FA_DEPRN_DETAIL DD_BONUS,
648: ( SELECT
649: DISTRIBUTION_ID ,
650: MAX(PERIOD_COUNTER) PERIOD_COUNTER
651: FROM FA_DEPRN_DETAIL
652: WHERE BOOK_TYPE_CODE = book
653: AND PERIOD_COUNTER <= upc
654: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
655: GROUP BY DISTRIBUTION_ID

Line 657: FA_DEPRN_DETAIL DD_BONUS ,

653: AND PERIOD_COUNTER <= upc
654: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
655: GROUP BY DISTRIBUTION_ID
656: ) DD1,
657: FA_DEPRN_DETAIL DD_BONUS ,
658: FA_DISTRIBUTION_HISTORY DH ,
659: FA_ASSET_HISTORY AH ,
660: FA_BOOKS BOOKS ,
661: FA_TRANSACTION_HEADERS TH_RT,

Line 734: Index(DD FA_DEPRN_DETAIL_U1)

730: BONUS_RATE ,
731: ASSET_COST_ACCT
732: )
733: SELECT /*+ ORDERED
734: Index(DD FA_DEPRN_DETAIL_U1)
735: index(DH FA_DISTRIBUTION_HISTORY_U1)
736: Index(AH FA_ASSET_HISTORY_N2)
737: */
738: DH.ASSET_ID ASSET_ID ,

Line 758: --FA_DEPRN_DETAIL_MRC_V DD,

754: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
755: BR.BONUS_RATE ,
756: CB.ASSET_COST_ACCT
757: FROM
758: --FA_DEPRN_DETAIL_MRC_V DD,
759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
760: MAX(PERIOD_COUNTER) PERIOD_COUNTER
761: FROM FA_DEPRN_DETAIL_MRC_V
762: WHERE BOOK_TYPE_CODE = book

Line 759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

755: BR.BONUS_RATE ,
756: CB.ASSET_COST_ACCT
757: FROM
758: --FA_DEPRN_DETAIL_MRC_V DD,
759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
760: MAX(PERIOD_COUNTER) PERIOD_COUNTER
761: FROM FA_DEPRN_DETAIL_MRC_V
762: WHERE BOOK_TYPE_CODE = book
763: AND PERIOD_COUNTER <= upc

Line 761: FROM FA_DEPRN_DETAIL_MRC_V

757: FROM
758: --FA_DEPRN_DETAIL_MRC_V DD,
759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
760: MAX(PERIOD_COUNTER) PERIOD_COUNTER
761: FROM FA_DEPRN_DETAIL_MRC_V
762: WHERE BOOK_TYPE_CODE = book
763: AND PERIOD_COUNTER <= upc
764: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
765: GROUP BY DISTRIBUTION_ID

Line 767: FA_DEPRN_DETAIL_MRC_V DD ,

763: AND PERIOD_COUNTER <= upc
764: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
765: GROUP BY DISTRIBUTION_ID
766: ) dd1,
767: FA_DEPRN_DETAIL_MRC_V DD ,
768: FA_DISTRIBUTION_HISTORY DH ,
769: FA_ASSET_HISTORY AH ,
770: FA_BOOKS_MRC_V BOOKS ,
771: FA_TRANSACTION_HEADERS TH ,

Line 838: Index(DD FA_DEPRN_DETAIL_U1)

834: ASSET_COST_ACCT
835: )
836: SELECT
837: /*+ ORDERED
838: Index(DD FA_DEPRN_DETAIL_U1)
839: index(DH FA_DISTRIBUTION_HISTORY_U1)
840: Index(AH FA_ASSET_HISTORY_N2)
841: */
842: DH.ASSET_ID ASSET_ID ,

Line 862: --FA_DEPRN_DETAIL DD,

858: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
859: BR.BONUS_RATE ,
860: CB.ASSET_COST_ACCT
861: FROM
862: --FA_DEPRN_DETAIL DD,
863: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
864: MAX(PERIOD_COUNTER) PERIOD_COUNTER
865: FROM FA_DEPRN_DETAIL
866: WHERE BOOK_TYPE_CODE = book

Line 863: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,

859: BR.BONUS_RATE ,
860: CB.ASSET_COST_ACCT
861: FROM
862: --FA_DEPRN_DETAIL DD,
863: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
864: MAX(PERIOD_COUNTER) PERIOD_COUNTER
865: FROM FA_DEPRN_DETAIL
866: WHERE BOOK_TYPE_CODE = book
867: AND PERIOD_COUNTER <= upc

Line 865: FROM FA_DEPRN_DETAIL

861: FROM
862: --FA_DEPRN_DETAIL DD,
863: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
864: MAX(PERIOD_COUNTER) PERIOD_COUNTER
865: FROM FA_DEPRN_DETAIL
866: WHERE BOOK_TYPE_CODE = book
867: AND PERIOD_COUNTER <= upc
868: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
869: GROUP BY DISTRIBUTION_ID

Line 871: FA_DEPRN_DETAIL DD ,

867: AND PERIOD_COUNTER <= upc
868: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
869: GROUP BY DISTRIBUTION_ID
870: ) DD1,
871: FA_DEPRN_DETAIL DD ,
872: FA_DISTRIBUTION_HISTORY DH ,
873: FA_ASSET_HISTORY AH ,
874: FA_BOOKS BOOKS ,
875: FA_TRANSACTION_HEADERS TH ,

Line 991: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

987: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
988: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
989: AND DD.PERIOD_COUNTER =
990: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
991: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
992: WHERE DD_SUB.BOOK_TYPE_CODE = book
993: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
994: AND DD_SUB.PERIOD_COUNTER <= upc
995: )

Line 1076: FROM FA_DEPRN_DETAIL DD_SUB

1072: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1073: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1074: AND DD.PERIOD_COUNTER =
1075: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
1076: FROM FA_DEPRN_DETAIL DD_SUB
1077: WHERE DD_SUB.BOOK_TYPE_CODE = book
1078: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1079: AND DD_SUB.PERIOD_COUNTER <= upc
1080: )

Line 1157: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1153: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1154: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1155: AND DD.PERIOD_COUNTER =
1156: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
1157: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1158: WHERE DD_SUB.BOOK_TYPE_CODE = book
1159: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1160: AND DD_SUB.PERIOD_COUNTER <= upc
1161: )

Line 1235: FROM FA_DEPRN_DETAIL DD_SUB

1231: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1232: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1233: AND DD.PERIOD_COUNTER =
1234: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
1235: FROM FA_DEPRN_DETAIL DD_SUB
1236: WHERE DD_SUB.BOOK_TYPE_CODE = book
1237: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1238: AND DD_SUB.PERIOD_COUNTER <= upc
1239: )