DBA Data[Home] [Help]

APPS.CN_SRP_PERIODS_PVT dependencies on CN_ACC_PERIOD_STATUSES_V

Line 38: FROM cn_acc_period_statuses_v

34:
35: BEGIN
36: SELECT MIN(start_date), MAX(end_date)
37: INTO l_start_date, l_end_date
38: FROM cn_acc_period_statuses_v
39: WHERE period_status IN ('O','F')
40: AND org_id = p_org_id
41: AND ( ( p_end_date IS NOT NULL AND start_date <= p_end_date
42: AND end_date >= p_start_date )