APPS.IGI_DOS_FUNDS dependencies on IGI_DOS_TRX_DEST

Line 80: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

76: l_serial_id gl_bc_packets.serial_id%type;
77: l_application_id gl_bc_packets.application_id%type;
78:
79:
80: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
81: IS
82: SELECT *
83: FROM igi_dos_trx_dest
84: WHERE trx_id = P_trx_id

Line 83: FROM igi_dos_trx_dest

79:
80: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
81: IS
82: SELECT *
83: FROM igi_dos_trx_dest
84: WHERE trx_id = P_trx_id
85: AND source_trx_id = p_source_trx_id;
86:
87: BEGIN

Line 443: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

439: FROM igi_dos_trx_sources
440: WHERE trx_id = l_trx_id;
441:
442: -- Bug 1635678 sekhar kappaga
443: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
444: IS
445: SELECT *
446: FROM igi_dos_trx_dest
447: WHERE trx_id = l_trx_id

Line 446: FROM igi_dos_trx_dest

442: -- Bug 1635678 sekhar kappaga
443: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
444: IS
445: SELECT *
446: FROM igi_dos_trx_dest
447: WHERE trx_id = l_trx_id
448: AND source_trx_id = p_source_trx_id;
449:
450: CURSOR get_currency_code

Line 608: FROM igi_dos_trx_dest dest

604:
605: --get the total amount for the source budget journal
606: SELECT nvl(sum(dest.budget_amount),0)
607: INTO v_source_amount
608: FROM igi_dos_trx_dest dest
609: WHERE dest.source_trx_id = packet_rec.source_trx_id;
610:
611: -- =============== START DEBUG LOG ================
612: Debug_log_string (l_proc_level, 'Approve.Msg35',

Line 939: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

935: v_encumbrance_type_id NUMBER;
936: l_currency_code VARCHAR2(15);
937:
938: -- Bug 1635678 sekhar kappaga
939: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
940: IS
941: SELECT *
942: FROM igi_dos_trx_dest
943: WHERE trx_id = l_trx_id

Line 942: FROM igi_dos_trx_dest

938: -- Bug 1635678 sekhar kappaga
939: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
940: IS
941: SELECT *
942: FROM igi_dos_trx_dest
943: WHERE trx_id = l_trx_id
944: AND source_trx_id = p_source_trx_id;
945:
946:

Line 1108: FROM igi_dos_trx_dest dest

1104:
1105:
1106: SELECT nvl(sum(dest.budget_amount),0)
1107: INTO v_source_amount
1108: FROM igi_dos_trx_dest dest
1109: WHERE dest.source_trx_id = packet_rec.source_trx_id;
1110:
1111: -- =============== START DEBUG LOG ================
1112: Debug_log_string (l_proc_level, 'Reject.Msg28',