DBA Data[Home] [Help]

APPS.CSE_IFA_TRANS_PKG dependencies on FA_MASS_EXTERNAL_TRANSFERS_S

Line 63: select fa_mass_external_transfers_s.nextval

59:
60: l_from_units := -p_units;
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

Line 108: select fa_mass_external_transfers_s.nextval

104: sysdate,
105: sysdate);
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

Line 362: select fa_mass_external_transfers_s.nextval

358: l_employee_id
359: from fa_distribution_history
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 ' ||

Line 409: select fa_mass_external_transfers_s.nextval

405:
406: l_from_units := -p_units;
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

Line 454: select fa_mass_external_transfers_s.nextval

450: sysdate,
451: sysdate);
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

Line 571: select fa_mass_external_transfers_s.nextval

567: close c_dist1;
568:
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