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

Line 5328: ,gl_period_statuses gps

5324: period_net_cr_beq period_activity_led_curr
5325: FROM gl_balances bal
5326: ,gl_ledgers led
5327: ,okl_code_cmbns_gt cc_gt
5328: ,gl_period_statuses gps
5329: WHERE led.ledger_id = p_ledger_id
5330: AND bal.ledger_id = led.ledger_id
5331: AND gps.application_id = 101
5332: and gps.ledger_id = led.ledger_id

Line 5335: from gl_period_statuses pf

5331: AND gps.application_id = 101
5332: and gps.ledger_id = led.ledger_id
5333: and bal.period_name = gps.period_name
5334: and gps.effective_period_num >= ( select pf.effective_period_num
5335: from gl_period_statuses pf
5336: where pf.application_id = 101
5337: and pf.ledger_id = p_ledger_id
5338: and pf.period_name = p_period_from
5339: and rownum < 2

Line 5342: from gl_period_statuses pt

5338: and pf.period_name = p_period_from
5339: and rownum < 2
5340: )
5341: and gps.effective_period_num <= ( select pt.effective_period_num
5342: from gl_period_statuses pt
5343: where pt.application_id = 101
5344: and pt.ledger_id = p_ledger_id
5345: and pt.period_name = p_period_to
5346: and rownum < 2

Line 5376: ,gl_period_statuses gps

5372: period_net_cr period_activity_led_curr
5373: FROM gl_balances bal
5374: ,gl_ledgers led
5375: ,okl_code_cmbns_gt cc_gt
5376: ,gl_period_statuses gps
5377: WHERE led.ledger_id = p_ledger_id
5378: AND gps.application_id = 101
5379: and gps.ledger_id = led.ledger_id
5380: and bal.period_name = gps.period_name

Line 5382: from gl_period_statuses pf

5378: AND gps.application_id = 101
5379: and gps.ledger_id = led.ledger_id
5380: and bal.period_name = gps.period_name
5381: and gps.effective_period_num >= ( select pf.effective_period_num
5382: from gl_period_statuses pf
5383: where pf.application_id = 101
5384: and pf.ledger_id = p_ledger_id
5385: and pf.period_name = p_period_from
5386: and rownum < 2

Line 5389: from gl_period_statuses pt

5385: and pf.period_name = p_period_from
5386: and rownum < 2
5387: )
5388: and gps.effective_period_num <= ( select pt.effective_period_num
5389: from gl_period_statuses pt
5390: where pt.application_id = 101
5391: and pt.ledger_id = p_ledger_id
5392: and pt.period_name = p_period_to
5393: and rownum < 2

Line 7350: FROM gl_period_statuses gl

7346:
7347: -- Cursor to fetch GL Period From Date
7348: CURSOR get_period_from_date IS
7349: SELECT gl.start_date from_date
7350: FROM gl_period_statuses gl
7351: WHERE gl.application_id = 540
7352: AND gl.set_of_books_id = p_ledger_id
7353: AND gl.period_name = p_gl_period_from;
7354:

Line 7358: FROM gl_period_statuses gl

7354:
7355: -- Cursor to fetch GL Period To Date
7356: CURSOR get_period_to_date IS
7357: SELECT gl.end_date to_date
7358: FROM gl_period_statuses gl
7359: WHERE gl.application_id = 540
7360: AND gl.set_of_books_id = p_ledger_id
7361: AND gl.period_name = p_gl_period_to;
7362: