APPS.CN_CALC_SUB_BATCHES_PKG dependencies on CN_PROCESS_BATCHES_ALL

Line 575: FROM cn_process_batches_all pb

571: x_calc_sub_batch_rec.calc_type,
572: x_calc_sub_batch_rec.interval_type_id
573: FROM cn_calc_submission_batches_all csb
574: WHERE csb.logical_batch_id = (SELECT pb.logical_batch_id
575: FROM cn_process_batches_all pb
576: WHERE pb.physical_batch_id = p_physical_batch_id
577: AND rownum = 1);
578:
579: END get_calc_sub_batch;

Line 598: from cn_process_batches_all pb

594: select intelligent_flag
595: into x_return
596: from cn_calc_submission_batches_all csb
597: where csb.logical_batch_id = (select logical_batch_id
598: from cn_process_batches_all pb
599: where pb.physical_batch_id = p_calc_batch_id
600: and rownum = 1);
601:
602: RETURN x_return;

Line 626: from cn_process_batches_all pb

622: select calc_type
623: into l_calc_type
624: from cn_calc_submission_batches_all csb
625: where csb.logical_batch_id = (select logical_batch_id
626: from cn_process_batches_all pb
627: where pb.physical_batch_id = p_calc_batch_id
628: and rownum = 1);
629:
630: IF l_calc_type = 'FORECAST' THEN

Line 659: from cn_process_batches_all pb

655: select calc_type
656: into x_return
657: from cn_calc_submission_batches_all csb
658: where csb.logical_batch_id = (select logical_batch_id
659: from cn_process_batches_all pb
660: where pb.physical_batch_id = p_calc_batch_id
661: and rownum = 1);
662:
663: RETURN x_return;

Line 686: from cn_process_batches_all pb

682: select salesrep_option
683: into x_return
684: from cn_calc_submission_batches_all csb
685: where csb.logical_batch_id = (select logical_batch_id
686: from cn_process_batches_all pb
687: where pb.physical_batch_id = p_calc_batch_id
688: and rownum = 1);
689:
690: RETURN x_return;