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

Line 194: from org_acct_periods

190:
191: BEGIN
192: select trunc (schedule_close_date), open_flag
193: into l_from_date_per_close, l_per_open_flag
194: from org_acct_periods
195: where organization_id = i_org_id
196: and period_start_date <= trunc (l_from_date)
197: and schedule_close_date >= trunc (l_from_date);
198:

Line 347: from org_acct_periods

343: */
344: BEGIN
345: select period_start_date
346: into l_look_for_txn_id
347: from org_acct_periods
348: where organization_id = i_org_id
349: and period_start_date <= trunc (l_push_inv_start_date)
350: and schedule_close_date >= trunc (l_push_inv_start_date);
351: EXCEPTION

Line 549: from org_acct_periods

545:
546: BEGIN
547: select period_start_date
548: into l_look_for_txn_id
549: from org_acct_periods
550: where organization_id = i_org_id
551: and period_start_date <= trunc (l_push_inv_start_date)
552: and schedule_close_date >= trunc (l_push_inv_start_date);
553: EXCEPTION

Line 729: from org_acct_periods oap

725: trunc (oap.period_close_date) --Dinkar 10/11/02
726: into l_per_start_date,
727: l_sched_close_date,
728: l_per_close_date
729: from org_acct_periods oap
730: where organization_id = i_org_id
731: and oap.period_start_date <= l_from_date
732: and oap.schedule_close_date >= l_from_date;
733: