APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PROCESS_BATCHES

Line 2115: FROM cn_process_batches

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

Line 4117: SELECT cn_process_batches_s2.NEXTVAL

4113:
4114: l_max_batch_id := p_salesrep_tbl(p_salesrep_tbl.COUNT).batch_id;
4115:
4116: -- Get logical batch ID
4117: SELECT cn_process_batches_s2.NEXTVAL
4118: INTO l_logical_batch_id
4119: FROM sys.dual;
4120:
4121: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);

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

4117: SELECT cn_process_batches_s2.NEXTVAL
4118: INTO l_logical_batch_id
4119: FROM sys.dual;
4120:
4121: fnd_file.put_line(fnd_file.LOG,'Logical Batch ID in cn_process_batches_all = ' || l_logical_batch_id);
4122:
4123: FOR currbatch IN 1 .. l_max_batch_id
4124: LOOP
4125:

Line 4126: /* Load batches into cn_process_batches*/

4122:
4123: FOR currbatch IN 1 .. l_max_batch_id
4124: LOOP
4125:
4126: /* Load batches into cn_process_batches*/
4127: -- sequence s1 is for Physical batch id
4128: SELECT cn_process_batches_s3.NEXTVAL
4129: INTO l_physical_batch_id
4130: FROM sys.dual;

Line 4128: SELECT cn_process_batches_s3.NEXTVAL

4124: LOOP
4125:
4126: /* Load batches into cn_process_batches*/
4127: -- sequence s1 is for Physical batch id
4128: SELECT cn_process_batches_s3.NEXTVAL
4129: INTO l_physical_batch_id
4130: FROM sys.dual;
4131:
4132: FOR kk IN 1 .. p_salesrep_tbl.COUNT

Line 4136: INSERT INTO cn_process_batches

4132: FOR kk IN 1 .. p_salesrep_tbl.COUNT
4133: LOOP
4134: IF (p_salesrep_tbl(kk).batch_id = currbatch)
4135: THEN
4136: INSERT INTO cn_process_batches
4137: (process_batch_id,
4138: logical_batch_id,
4139: physical_batch_id,
4140: srp_period_id,

Line 4156: (cn_process_batches_s1.NEXTVAL,

4152: program_application_id,
4153: program_id,
4154: program_update_date)
4155: VALUES
4156: (cn_process_batches_s1.NEXTVAL,
4157: l_logical_batch_id,
4158: l_physical_batch_id,
4159: 1,
4160: 1,

Line 4432: FROM cn_process_batches

4428: l_worksheet_rec.payrun_id := p_payrun_id;
4429: l_worksheet_rec.org_id := p_org_id;
4430:
4431: FOR emp IN (SELECT salesrep_id
4432: FROM cn_process_batches
4433: WHERE logical_batch_id = p_logical_batch_id
4434: AND physical_batch_id = p_batch_id)
4435: LOOP
4436: -- Run refresh worksheet for this salesrep.