DBA Data[Home] [Help]

APPS.CN_PROC_BATCHES_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 3193: FROM cn_acc_period_statuses_v

3189: CURSOR l_chk_start_date_csr IS
3190: SELECT 1
3191: FROM DUAL
3192: WHERE EXISTS(SELECT 1
3193: FROM cn_acc_period_statuses_v
3194: WHERE period_status = 'O' AND org_id = l_org_id AND p_start_date >= start_date);
3195:
3196: CURSOR l_chk_end_date_csr IS
3197: SELECT 1

Line 3200: FROM cn_acc_period_statuses_v

3196: CURSOR l_chk_end_date_csr IS
3197: SELECT 1
3198: FROM DUAL
3199: WHERE EXISTS(SELECT 1
3200: FROM cn_acc_period_statuses_v
3201: WHERE period_status = 'O' AND org_id = l_org_id AND p_end_date <= end_date);
3202:
3203: CURSOR l_batch_name_csr IS
3204: SELECT 1