APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_PROCESS_AUDITS

Line 21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);

17: status cn_calc_submission_batches.status%TYPE,
18: interval_type_id cn_calc_submission_batches.interval_type_id%TYPE,
19: process_audit_id cn_calc_submission_batches.process_audit_id%TYPE,
20: object_version_number cn_calc_submission_batches.object_version_number%TYPE,
21: concurrent_request_id cn_process_audits.concurrent_request_id%TYPE);
22:
23: TYPE rep_entry_rec_type IS RECORD
24: (name jtf_rs_salesreps.name%TYPE,
25: employee_number jtf_rs_salesreps.salesrep_number%TYPE,

Line 764: FROM cn_process_audits

760:
761: -- Added to retrieve concurrent request id for enhancment#2651798
762: CURSOR get_conc_req_id (a_process_audit_id NUMBER) IS
763: SELECT concurrent_request_id
764: FROM cn_process_audits
765: WHERE process_audit_id = a_process_audit_id;
766:
767:
768: BEGIN

Line 816: from cn_process_audits_all

812: and concurrent_flag = 'Y'
813: and exists (select 1
814: from fnd_concurrent_requests
815: where request_id = (select concurrent_request_id
816: from cn_process_audits_all
817: where process_audit_id = sb.process_audit_id)
818: and status_code in ('E', 'X'));
819: commit;
820: EXCEPTION