DBA Data[Home] [Help]

APPS.CN_PROC_BATCHES_PKG dependencies on CN_ACC_PERIOD_STATUSES_V

Line 3192: FROM cn_acc_period_statuses_v

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

Line 3199: FROM cn_acc_period_statuses_v

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