APPS.CN_COMMISSION_CALC_PVT dependencies on CN_PERIOD_STATUSES

Line 485: FROM cn_period_statuses cps

481: SET line_id = cn_proj_compensation_gtt_s.NEXTVAL
482: , cpcg.period_id =
483: (
484: SELECT cps.period_id period_id
485: FROM cn_period_statuses cps
486: WHERE cps.period_set_id = l_repositories.period_set_id
487: AND cps.period_type_id = l_repositories.period_type_id
488: AND cpcg.calc_date between cps.start_date and cps.end_Date
489: AND cps.period_status = 'O'