eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ARXKIR_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 51: GL_PERIOD_STATUSES GPS

47: ,0) CURRENT_YEAR_CUSTOMER_COUNT
48: INTO CURRENT_CUSTOMER_COUNT,PRIOR_CUSTOMER_COUNT,CURRENT_YEAR_CUSTOMER_COUNT
49: FROM
50: HZ_CUST_ACCOUNTS C,
51: GL_PERIOD_STATUSES GPS
52: WHERE C.CREATION_DATE BETWEEN GPS.START_DATE
53: AND GPS.END_DATE
54: AND GPS.APPLICATION_ID = 222
55: AND GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP

Line 82: GL_PERIOD_STATUSES GPS

78: ,0) PRIOR_YEAR_COUNT
79: INTO CURRENT_LOCATION_COUNT,PRIOR_LOCATION_COUNT,PRIOR_YEAR_COUNT
80: FROM
81: HZ_CUST_ACCT_SITES A,
82: GL_PERIOD_STATUSES GPS
83: WHERE A.CREATION_DATE BETWEEN GPS.START_DATE
84: AND GPS.END_DATE
85: AND GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP
86: AND GPS.APPLICATION_ID = 222

Line 111: GL_PERIOD_STATUSES GPS

107: ,0) YEAR_ON_HOLD_Y_COUNT
108: INTO CURRENT_ON_HOLD_Y_COUNT,PRIOR_ON_HOLD_Y_COUNT,YEAR_ON_HOLD_Y_COUNT
109: FROM
110: AR_CREDIT_HISTORIES CH,
111: GL_PERIOD_STATUSES GPS
112: WHERE CH.CREATION_DATE BETWEEN GPS.START_DATE
113: AND GPS.END_DATE
114: AND CH.ON_HOLD = 'Y'
115: AND GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP

Line 141: GL_PERIOD_STATUSES GPS

137: ,0) YEAR_ON_HOLD_N_COUNT
138: INTO CURRENT_ON_HOLD_N_COUNT,PRIOR_ON_HOLD_N_COUNT,YEAR_ON_HOLD_N_COUNT
139: FROM
140: AR_CREDIT_HISTORIES CH,
141: GL_PERIOD_STATUSES GPS
142: WHERE CH.CREATION_DATE BETWEEN GPS.START_DATE
143: AND GPS.END_DATE
144: AND CH.ON_HOLD = 'N'
145: AND GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP

Line 171: GL_PERIOD_STATUSES GPS

167: AR_CASH_RECEIPTS CR,
168: AR_RECEIPT_METHODS RM,
169: AR_RECEIPT_CLASSES RC,
170: AR_CASH_RECEIPT_HISTORY CRH,
171: GL_PERIOD_STATUSES GPS
172: WHERE CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
173: AND RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
174: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
175: AND CRH.FIRST_POSTED_RECORD_FLAG = 'Y'

Line 202: GL_PERIOD_STATUSES GPS

198: ,0) PRIOR_BATCH_PER_DAY
199: INTO CURRENT_BATCH_PER_DAY,PRIOR_BATCH_PER_DAY
200: FROM
201: AR_BATCHES B,
202: GL_PERIOD_STATUSES GPS
203: WHERE GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP
204: AND GPS.APPLICATION_ID = 222
205: AND ( GPS.PERIOD_NAME = CURRENT_PERIOD
206: OR GPS.PERIOD_NAME = PRIOR_PERIOD )

Line 232: GL_PERIOD_STATUSES GPS

228: AR_RECEIPT_METHODS RM,
229: AR_RECEIPT_CLASSES RC,
230: AR_CASH_RECEIPT_HISTORY CRH,
231: AR_BATCHES B,
232: GL_PERIOD_STATUSES GPS
233: WHERE CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
234: AND RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
235: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
236: AND CRH.FIRST_POSTED_RECORD_FLAG = 'Y'