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.XLA_TP_SUMMARY_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 75: FROM gl_period_statuses GPS

71: /* Query to fetch the Effective period number from */
72: BEGIN
73: SELECT effective_period_num
74: INTO P_PERIOD_NUM_FROM
75: FROM gl_period_statuses GPS
76: WHERE GPS.period_name=P_PERIOD_FROM
77: AND GPS.application_id=101
78: AND GPS.ledger_id=P_LEDGER_ID;
79: END;

Line 84: FROM gl_period_statuses GPS

80: /* Query to fetch the Effective period number to */
81: BEGIN
82: SELECT effective_period_num
83: INTO P_PERIOD_NUM_TO
84: FROM gl_period_statuses GPS
85: WHERE GPS.period_name=P_PERIOD_TO
86: AND GPS.application_id=101
87: AND GPS.ledger_id=P_LEDGER_ID;
88: END;

Line 95: FROM gl_period_statuses

91: /* Query to fetch the Period From which exist in the Control Balances Table.
92: BEGIN
93: SELECT period_name
94: INTO P_AC_PERIOD_FROM
95: FROM gl_period_statuses
96: WHERE effective_period_num=(
97: SELECT MIN(GPS.effective_period_num)
98: FROM gl_period_statuses GPS, xla_control_balances XCB
99: WHERE GPS.effective_period_num BETWEEN P_PERIOD_NUM_FROM

Line 98: FROM gl_period_statuses GPS, xla_control_balances XCB

94: INTO P_AC_PERIOD_FROM
95: FROM gl_period_statuses
96: WHERE effective_period_num=(
97: SELECT MIN(GPS.effective_period_num)
98: FROM gl_period_statuses GPS, xla_control_balances XCB
99: WHERE GPS.effective_period_num BETWEEN P_PERIOD_NUM_FROM
100: AND P_PERIOD_NUM_TO
101: AND XCB.period_name=GPS.period_name
102: AND XCB.ledger_id=GPS.ledger_id

Line 117: FROM gl_period_statuses

113: /* Query to fetch the Period To which exist in the Control Balances Table.
114: BEGIN
115: SELECT period_name
116: INTO P_AC_PERIOD_TO
117: FROM gl_period_statuses
118: WHERE effective_period_num=(
119: SELECT MAX(GPS.effective_period_num)
120: FROM gl_period_statuses GPS, xla_control_balances XCB
121: WHERE GPS.effective_period_num

Line 120: FROM gl_period_statuses GPS, xla_control_balances XCB

116: INTO P_AC_PERIOD_TO
117: FROM gl_period_statuses
118: WHERE effective_period_num=(
119: SELECT MAX(GPS.effective_period_num)
120: FROM gl_period_statuses GPS, xla_control_balances XCB
121: WHERE GPS.effective_period_num
122: BETWEEN P_PERIOD_NUM_FROM
123: AND P_PERIOD_NUM_TO
124: AND XCB.period_name=GPS.period_name

Line 264: FROM gl_period_statuses GPS

260: BEGIN
261: /*Query to find the minimum period existing in the control balances table */
262: SELECT MIN(p_period_num)
263: INTO ln_actual_per_num
264: FROM gl_period_statuses GPS
265: WHERE GPS.effective_period_num
266: BETWEEN P_PERIOD_NUM_FROM
267: AND P_PERIOD_NUM_TO
268: AND GPS.application_id=P_RESP_APPLICATION_ID

Line 288: FROM gl_period_statuses GPS

284: BEGIN
285: /*Query to find the maximum period existing in the control balances table */
286: SELECT MAX(p_period_num)
287: INTO ln_actual_per_num
288: FROM gl_period_statuses GPS
289: WHERE GPS.effective_period_num
290: BETWEEN P_PERIOD_NUM_FROM
291: AND P_PERIOD_NUM_TO
292: AND GPS.application_id=P_RESP_APPLICATION_ID