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.GL_ARCH_PRG_FROM_PRD_PKG dependencies on GL_ARCHIVE_HISTORY

Line 33: GL_ARCHIVE_HISTORY AH

29: AND PS.effective_period_num >
30: (SELECT
31: NVL(MAX(AH.last_archived_eff_period_num), 0)
32: FROM
33: GL_ARCHIVE_HISTORY AH
34: WHERE
35: AH.ledger_id = x_ledger_id
36: AND AH.data_type = x_data_type
37: AND AH.actual_flag = x_actual_flag)

Line 100: GL_ARCHIVE_HISTORY AH

96: AND PS.effective_period_num >
97: (SELECT
98: NVL(MAX(AH.last_purged_eff_period_num), 0)
99: FROM
100: GL_ARCHIVE_HISTORY AH
101: WHERE
102: AH.ledger_id = x_ledger_id
103: AND AH.actual_flag = x_actual_flag
104: AND AH.data_type = x_data_type )

Line 109: GL_ARCHIVE_HISTORY AH

105: AND PS.effective_period_num <=
106: (SELECT
107: NVL(MAX(AH.last_archived_eff_period_num), -1)
108: FROM
109: GL_ARCHIVE_HISTORY AH
110: WHERE
111: AH.ledger_id = x_ledger_id
112: AND AH.data_type = x_data_type
113: AND AH.actual_flag = x_actual_flag)

Line 175: GL_ARCHIVE_HISTORY AH

171: AND PS.effective_period_num >
172: (SELECT
173: NVL(MAX(AH.last_purged_eff_period_num), 0)
174: FROM
175: GL_ARCHIVE_HISTORY AH
176: WHERE
177: AH.ledger_id = x_ledger_id
178: AND AH.data_type = x_data_type
179: AND AH.actual_flag = x_actual_flag)

Line 240: GL_ARCHIVE_HISTORY AH

236: AND ( BPR.period_year * 10000 + BPR.start_period_num ) >
237: (SELECT
238: NVL(MAX(AH.last_archived_eff_period_num), 0)
239: FROM
240: GL_ARCHIVE_HISTORY AH
241: WHERE
242: AH.ledger_id = x_ledger_id
243: AND AH.data_type = x_data_type
244: AND AH.actual_flag = x_actual_flag

Line 303: GL_ARCHIVE_HISTORY AH

299: AND ( BPR.period_year * 10000 + BPR.start_period_num ) >
300: (SELECT
301: NVL(MAX(AH.last_purged_eff_period_num), 0)
302: FROM
303: GL_ARCHIVE_HISTORY AH
304: WHERE
305: AH.ledger_id = x_ledger_id
306: AND AH.data_type = x_data_type
307: AND AH.actual_flag = x_actual_flag

Line 313: GL_ARCHIVE_HISTORY AH

309: AND ( BPR.period_year * 10000 + BPR.start_period_num ) <=
310: (SELECT
311: NVL(MAX(AH.last_archived_eff_period_num), 0)
312: FROM
313: GL_ARCHIVE_HISTORY AH
314: WHERE
315: AH.ledger_id = x_ledger_id
316: AND AH.data_type = x_data_type
317: AND AH.actual_flag = x_actual_flag

Line 375: GL_ARCHIVE_HISTORY AH

371: AND ( BPR.period_year * 10000 + BPR.start_period_num ) >
372: (SELECT
373: NVL(MAX(AH.last_purged_eff_period_num), 0)
374: FROM
375: GL_ARCHIVE_HISTORY AH
376: WHERE
377: AH.ledger_id = x_ledger_id
378: AND AH.data_type = x_data_type
379: AND AH.actual_flag = x_actual_flag