APPS.CN_PROC_BATCHES_PKG dependencies on CN_SRP_PAYEE_ASSIGNS

Line 2230: FROM cn_srp_payee_assigns a

2226: l_payee_count := 0;
2227:
2228: SELECT COUNT(*)
2229: INTO l_payee_count
2230: FROM cn_srp_payee_assigns a
2231: WHERE a.start_date <= l_end_date AND(a.end_date IS NULL OR a.end_date >= l_start_date);
2232:
2233: FOR physical_rec IN physical_batches LOOP
2234: conc_submit(

Line 2636: FROM cn_srp_payee_assigns a

2632: l_payee_count := 0;
2633:
2634: SELECT COUNT(*)
2635: INTO l_payee_count
2636: FROM cn_srp_payee_assigns a
2637: WHERE a.start_date <= l_end_date AND(a.end_date IS NULL OR a.end_date >= l_start_date);
2638:
2639: -- get highest successful phase of completion for each batch
2640: FOR physical_batch IN physical_batches LOOP