DBA Data[Home] [Help]

APPS.IGF_AW_COA_CALC dependencies on DUAL

Line 2158: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;

2154: IF (cur_per_grp%NOTFOUND) THEN
2155: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
2156: fnd_file.put_line(fnd_file.log,fnd_message.get);
2157: ELSE
2158: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2159: populate_setup_table(p_grp_code,l_ci_cal_type,l_ci_sequence_number,l_process_id);
2160:
2161: OPEN c_group_code(p_pergrp_id);
2162: FETCH c_group_code INTO c_grp_cd;

Line 2209: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;

2205:
2206: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
2207:
2208: ELSIF l_run_type = 'S' AND (p_pergrp_id is NULL) AND (p_base_id IS NOT NULL) THEN
2209: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2210: populate_setup_table(
2211: p_grp_code,
2212: l_ci_cal_type,
2213: l_ci_sequence_number,

Line 2232: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;

2228: fnd_message.set_name('IGF','IGF_AW_COA_NO_STDS');
2229: fnd_file.put_line(fnd_file.log,fnd_message.get);
2230: fnd_file.new_line(fnd_file.log,1);
2231: ELSE
2232: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2233: populate_setup_table(
2234: p_grp_code,
2235: l_ci_cal_type,
2236: l_ci_sequence_number,