DBA Data[Home] [Help]

APPS.INV_PURGE_PUB dependencies on INV_LE_TIMEZONE_PUB

Line 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)

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';
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN

Line 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)

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';
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: fnd_msg_pub.initialize;