APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PROCESS_BATCHES

Line 2117: FROM cn_process_batches

2113: l_worksheet_rec.org_id := p_org_id;
2114: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
2115:
2116: FOR emp IN (SELECT salesrep_id
2117: FROM cn_process_batches
2118: WHERE logical_batch_id = p_logical_batch_id
2119: AND physical_batch_id = p_batch_id)
2120: LOOP
2121:

Line 4163: SELECT cn_process_batches_s2.NEXTVAL

4159:
4160: l_max_batch_id := p_salesrep_tbl(p_salesrep_tbl.COUNT).batch_id;
4161:
4162: -- Get logical batch ID
4163: SELECT cn_process_batches_s2.NEXTVAL
4164: INTO l_logical_batch_id
4165: FROM sys.dual;
4166:
4167: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);

Line 4167: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);

4163: SELECT cn_process_batches_s2.NEXTVAL
4164: INTO l_logical_batch_id
4165: FROM sys.dual;
4166:
4167: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);
4168:
4169: FOR currbatch IN 1 .. l_max_batch_id
4170: LOOP
4171:

Line 4172: /* Load batches into cn_process_batches*/

4168:
4169: FOR currbatch IN 1 .. l_max_batch_id
4170: LOOP
4171:
4172: /* Load batches into cn_process_batches*/
4173: -- sequence s1 is for Physical batch id
4174: SELECT cn_process_batches_s3.NEXTVAL
4175: INTO l_physical_batch_id
4176: FROM sys.dual;

Line 4174: SELECT cn_process_batches_s3.NEXTVAL

4170: LOOP
4171:
4172: /* Load batches into cn_process_batches*/
4173: -- sequence s1 is for Physical batch id
4174: SELECT cn_process_batches_s3.NEXTVAL
4175: INTO l_physical_batch_id
4176: FROM sys.dual;
4177:
4178: FOR kk IN 1 .. p_salesrep_tbl.COUNT

Line 4182: INSERT INTO cn_process_batches

4178: FOR kk IN 1 .. p_salesrep_tbl.COUNT
4179: LOOP
4180: IF (p_salesrep_tbl(kk).batch_id = currbatch)
4181: THEN
4182: INSERT INTO cn_process_batches
4183: (process_batch_id,
4184: logical_batch_id,
4185: physical_batch_id,
4186: srp_period_id,

Line 4202: (cn_process_batches_s1.NEXTVAL,

4198: program_application_id,
4199: program_id,
4200: program_update_date)
4201: VALUES
4202: (cn_process_batches_s1.NEXTVAL,
4203: l_logical_batch_id,
4204: l_physical_batch_id,
4205: 1,
4206: 1,

Line 4499: FROM cn_process_batches

4495: l_worksheet_rec.payrun_id := p_payrun_id;
4496: l_worksheet_rec.org_id := p_org_id;
4497:
4498: FOR emp IN (SELECT salesrep_id
4499: FROM cn_process_batches
4500: WHERE logical_batch_id = p_logical_batch_id
4501: AND physical_batch_id = p_batch_id)
4502: LOOP
4503: -- Run refresh worksheet for this salesrep.