APPS.AR_CMGT_CONTROLS dependencies on DUAL

Line 81: FROM dual;

77: END;
78:
79: SELECT ar_cmgt_cf_dtls_s.nextval
80: INTO p_case_folder_detail_id
81: FROM dual;
82:
83: INSERT INTO ar_cmgt_cf_dtls
84: ( case_folder_detail_id,
85: case_folder_id,

Line 149: FROM DUAL;

145: IF (p_case_folder_id IS NULL) OR (p_case_folder_id = -99)
146: THEN
147: SELECT ar_cmgt_case_folders_s.nextval
148: INTO l_case_folder_id
149: FROM DUAL;
150: ELSE
151: l_case_folder_id := p_case_folder_id;
152: END IF;
153: IF p_case_folder_number IS NULL

Line 157: FROM DUAL;

153: IF p_case_folder_number IS NULL
154: THEN
155: SELECT ar_cmgt_case_folder_number_s.nextval
156: INTO l_case_folder_number
157: FROM DUAL;
158: ELSE
159: l_case_folder_number := p_case_folder_number;
160: END IF;
161: INSERT INTO ar_cmgt_case_folders (

Line 452: FROM dual;

448:
449: BEGIN
450: SELECT ar_cmgt_data_points_s.nextval
451: INTO p_data_point_id
452: FROM dual;
453:
454: AR_CMGT_DP_TABLE_HANDLER.insert_row(
455: p_data_point_name => p_data_point_name,
456: p_description => null,

Line 503: FROM dual;

499: BEGIN
500:
501: SELECT ar_cmgt_data_points_s.nextval
502: INTO l_dp_id
503: FROM dual;
504:
505: x_data_point_id := l_dp_id;
506:
507: AR_CMGT_DP_TABLE_HANDLER.insert_adp_row(

Line 739: FROM dual;

735: BEGIN
736:
737: SELECT ar_cmgt_cf_dtls_s.NEXTVAL
738: INTO l_seq_num
739: FROM dual;
740:
741: --store the parent_rec_id and corrosponding seq_num_id
742:
743: l_rec_changed.parent := select_dtls_rec.CASE_FOLDER_DETAIL_ID;

Line 1286: INTO l_next_val FROM dual;

1282:
1283: l_data_point_id := bank_data_rec.DATAPOINT_ID;
1284:
1285: SELECT AR_CMGT_BANK_REF_DATA_S.NEXTVAL
1286: INTO l_next_val FROM dual;
1287:
1288: INSERT INTO ar_cmgt_bank_ref_data
1289: (DATAPOINT_ID,
1290: CREDIT_REQUEST_ID,