APPS.IGF_AW_GEN_004 dependencies on DUAL

Line 1135: FROM DUAL

1131: p_param7,
1132: p_flag
1133: ) data2,
1134: 1 seq
1135: FROM DUAL
1136: UNION
1137: SELECT DISTINCT
1138: fmast.fund_code, fmast.fund_id, '' || fmast.description || '' data1,
1139: get_award_data (

Line 1195: FROM DUAL

1191: p_param7,
1192: p_flag
1193: ) data2,
1194: 3 seq
1195: FROM DUAL
1196: ORDER BY seq;
1197:
1198: /*get the rowid for the person in temp table for deletion*/
1199: CURSOR get_pers_del IS

Line 1386: OPEN l_query_desc FOR select DISTINCT p_person_id person_id FROM DUAL;

1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: p_exception := 'Y';
1384: RETURN;
1385: END IF;
1386: OPEN l_query_desc FOR select DISTINCT p_person_id person_id FROM DUAL;
1387: ELSIF p_select_type = 'G' THEN -- Select Type - S-Person/G-Group/A-Auto select
1388: IF p_list_id IS NULL THEN
1389: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_GRP');
1390: fnd_file.put_line(fnd_file.log,fnd_message.get);