APPS.CN_SCA_CREDITS_BATCH_PVT dependencies on CN_SCA_PROCESS_BATCHES

Line 50: l_start_id cn_sca_process_batches.start_id%TYPE;

46: l_process_audit_id NUMBER(15);
47: l_msg_count NUMBER;
48: l_msg_data VARCHAR2(2000);
49: l_return_status VARCHAR2(30);
50: l_start_id cn_sca_process_batches.start_id%TYPE;
51: l_end_id cn_sca_process_batches.end_id%TYPE;
52: l_org_id INTEGER;
53: l_package_name VARCHAR2(100);
54: l_stmt VARCHAR2(1000);

Line 51: l_end_id cn_sca_process_batches.end_id%TYPE;

47: l_msg_count NUMBER;
48: l_msg_data VARCHAR2(2000);
49: l_return_status VARCHAR2(30);
50: l_start_id cn_sca_process_batches.start_id%TYPE;
51: l_end_id cn_sca_process_batches.end_id%TYPE;
52: l_org_id INTEGER;
53: l_package_name VARCHAR2(100);
54: l_stmt VARCHAR2(1000);
55: l_winners_sql VARCHAR2(4000);

Line 133: FROM cn_sca_process_batches

129:
130: BEGIN
131: SELECT start_id, end_id
132: INTO l_start_id, l_end_id
133: FROM cn_sca_process_batches
134: WHERE sca_process_batch_id = p_physical_batch_id;
135: EXCEPTION
136: WHEN OTHERS THEN
137: debugmsg('Process Batch Rules: Invalid Physical Batch ID');