APPS.IGS_AS_GEN_004 dependencies on IGS_AS_EXMVNU_SESAVL

Line 108: FROM igs_as_exmvnu_sesavl

104: l_rowid VARCHAR2 (25);
105: v_evsa_exists VARCHAR2 (1);
106: CURSOR c_evsa IS
107: SELECT 'x'
108: FROM igs_as_exmvnu_sesavl
109: WHERE venue_cd = p_venue_cd
110: AND exam_cal_type = p_exam_cal_type
111: AND exam_ci_sequence_number = p_exam_ci_sequence_number;
112: CURSOR c_es IS

Line 141: igs_as_exmvnu_sesavl_pkg.insert_row (

137: FOR v_es_rec IN c_es LOOP
138: v_inserted_flag := TRUE;
139: --get org id
140: l_org_id := igs_ge_gen_003.get_org_id;
141: igs_as_exmvnu_sesavl_pkg.insert_row (
142: x_mode => 'R',
143: x_rowid => l_rowid,
144: x_org_id => l_org_id,
145: x_venue_cd => p_venue_cd,