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_RECURRING_VALID_PERIODS_PKG dependencies on GL_RECURRING_VALID_PERIODS_V

Line 15: FROM gl_recurring_valid_periods_v vp1,

11: x_next_period IN OUT NOCOPY VARCHAR2 ) IS
12:
13: CURSOR c_period IS
14: SELECT vp1.period_name
15: FROM gl_recurring_valid_periods_v vp1,
16: gl_recurring_valid_periods_v vp2
17: WHERE vp1.ledger_id = x_ledger_id
18: AND vp2.ledger_id = x_ledger_id
19: AND vp1.recurring_batch_id = x_recurring_batch_id

Line 16: gl_recurring_valid_periods_v vp2

12:
13: CURSOR c_period IS
14: SELECT vp1.period_name
15: FROM gl_recurring_valid_periods_v vp1,
16: gl_recurring_valid_periods_v vp2
17: WHERE vp1.ledger_id = x_ledger_id
18: AND vp2.ledger_id = x_ledger_id
19: AND vp1.recurring_batch_id = x_recurring_batch_id
20: AND vp2.recurring_batch_id = x_recurring_batch_id

Line 24: FROM gl_recurring_valid_periods_v vp3

20: AND vp2.recurring_batch_id = x_recurring_batch_id
21: AND vp2.period_name = x_period
22: AND ( vp1.start_date =
23: ( SELECT MIN( vp3.start_date )
24: FROM gl_recurring_valid_periods_v vp3
25: WHERE vp3.ledger_id = x_ledger_id
26: AND vp3.recurring_batch_id = x_recurring_batch_id
27: AND vp3.start_date > vp2.start_date ) );
28: