APPS.CN_MARK_EVENTS_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1059: FROM cn_acc_period_statuses_v acc

1055: SELECT acc.period_id
1056: , DECODE(acc.period_id, l_start_period_id, p_start_date, acc.start_date) start_date
1057: , DECODE(acc.period_id, l_end_period_id, NVL(p_end_date, acc.end_date), acc.end_date)
1058: end_date
1059: FROM cn_acc_period_statuses_v acc
1060: WHERE acc.period_id BETWEEN l_start_period_id AND l_end_period_id
1061: AND acc.period_status = 'O'
1062: AND acc.org_id = p_org_id
1063: ORDER BY acc.period_id DESC;