APPS.CSE_IFA_TRANS_PKG dependencies on DUAL

Line 65: from dual;

61:
62: -- Select sequence number
63: select fa_mass_external_transfers_s.nextval
64: into l_seq_num
65: from dual;
66:
67: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table
68:
69: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||

Line 110: from dual;

106:
107: -- Select sequence number
108: select fa_mass_external_transfers_s.nextval
109: into l_seq_num
110: from dual;
111:
112: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table
113:
114: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||

Line 364: from dual;

360: where distribution_id = l_temp_dist_id;
361:
362: select fa_mass_external_transfers_s.nextval
363: into l_seq_num
364: from dual;
365:
366: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
367: l_seq_num);
368:

Line 411: from dual;

407:
408: -- Select sequence number
409: select fa_mass_external_transfers_s.nextval
410: into l_seq_num
411: from dual;
412:
413: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table
414:
415: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||

Line 456: from dual;

452:
453: -- Select sequence number
454: select fa_mass_external_transfers_s.nextval
455: into l_seq_num
456: from dual;
457:
458: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table
459:
460: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||

Line 573: from dual;

569: -- Select sequence number
570:
571: select fa_mass_external_transfers_s.nextval
572: into l_seq_num
573: from dual;
574:
575: -- Insert the record into the FA_MASS_EXTERNAL_TRANSFERS interface table
576:
577: cse_util_pkg.write_log('Distribution exists. Inserting record with MASS_EXTERNAL_TRANSFER_ID ' || l_seq_num);