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

Line 451: FROM org_acct_periods

447: CURSOR l_extraction_periods_csr ( p_organization_id NUMBER,
448: p_from_date DATE, p_to_date DATE) IS
449: SELECT Trunc(period_start_date) start_date,
450: Trunc(schedule_close_date) end_date
451: FROM org_acct_periods
452: WHERE organization_id = p_organization_id
453: AND (( period_start_date between p_from_date
454: and p_to_date )
455: OR( schedule_close_date between p_from_date

Line 722: FROM org_acct_periods

718:
719: DECLARE
720: CURSOR prd_start_date_csr IS
721: SELECT period_start_date
722: FROM org_acct_periods
723: WHERE organization_id = org_id
724: AND period_start_date <= p_from_date
725: AND schedule_close_date >= p_from_date;
726:

Line 729: FROM org_acct_periods

725: AND schedule_close_date >= p_from_date;
726:
727: CURSOR prd_start_date_min_csr IS
728: SELECT MIN(period_start_date)
729: FROM org_acct_periods
730: WHERE organization_id = org_id
731: AND period_start_date BETWEEN p_from_date AND p_to_date;
732:
733: BEGIN

Line 1851: from org_acct_periods oap

1847: if(l_last_push_date is NOT NULL) THEN --{
1848: l_statement := 40;
1849: select max(oap.schedule_close_date)
1850: into l_purge_to_date
1851: from org_acct_periods oap
1852: where oap.organization_id = i_org_id
1853: and oap.period_close_date is not null
1854: and oap.schedule_close_date < l_last_push_date;
1855: