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.CST_MGD_MSTR_BOOK_RPT dependencies on ORG_ACCT_PERIODS

Line 347: FROM org_acct_periods f

343: -- Cursor to retrieve from accounting period id
344: CURSOR from_acct_period_cur(c_rpt_from_date DATE)
345: IS
346: SELECT f.acct_period_id
347: FROM org_acct_periods f
348: WHERE f.organization_id = p_org_id
349: AND f.period_start_date <= c_rpt_from_date
350: AND f.schedule_close_date >= c_rpt_from_date;
351:

Line 356: FROM org_acct_periods t

352: -- Cursor to retrieve to accounting period id
353: CURSOR to_acct_period_cur(c_rpt_to_date DATE)
354: IS
355: SELECT t.acct_period_id
356: FROM org_acct_periods t
357: WHERE t.organization_id = p_org_id
358: AND t.period_start_date <= c_rpt_to_date
359: AND t.schedule_close_date >= c_rpt_to_date;
360:

Line 2004: org_acct_periods f

2000: IS
2001: SELECT
2002: f.acct_period_id
2003: FROM
2004: org_acct_periods f
2005: WHERE f.organization_id = p_org_id
2006: AND f.period_start_date <= c_rpt_from_date
2007: AND f.schedule_close_date >= c_rpt_from_date
2008: AND F.Open_Flag = 'N'

Line 2017: org_acct_periods t

2013: IS
2014: SELECT
2015: t.acct_period_id
2016: FROM
2017: org_acct_periods t
2018: WHERE t.organization_id = p_org_id
2019: AND t.period_start_date <= c_rpt_to_date
2020: AND t.schedule_close_date >= c_rpt_to_date
2021: AND T.Open_Flag = 'N'