DBA Data[Home] [Help]

APPS.INV_PURGE_PUB dependencies on ORG_ACCT_PERIODS

Line 73: FROM org_acct_periods

69: -- accounting periods for the date specified
70: BEGIN
71: SELECT 1
72: INTO l_tempvar
73: FROM org_acct_periods
74: WHERE organization_id = p_orgid
75: AND period_start_date <= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
76: AND schedule_close_date >= inv_le_timezone_pub.get_le_day_for_inv_org(fnd_date.canonical_to_date(p_purge_date), p_orgid)
77: AND open_flag = 'N';