APPS.IGI_DOS_FUNDS dependencies on IGI_DOS_TRX_DEST

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

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

Line 86: FROM igi_dos_trx_dest

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

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

446: FROM igi_dos_trx_sources
447: WHERE trx_id = l_trx_id;
448:
449: -- Bug 1635678 sekhar kappaga
450: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
451: IS
452: SELECT *
453: FROM igi_dos_trx_dest
454: WHERE trx_id = l_trx_id

Line 453: FROM igi_dos_trx_dest

449: -- Bug 1635678 sekhar kappaga
450: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
451: IS
452: SELECT *
453: FROM igi_dos_trx_dest
454: WHERE trx_id = l_trx_id
455: AND source_trx_id = p_source_trx_id;
456:
457: CURSOR get_currency_code

Line 628: FROM igi_dos_trx_dest dest

624: -- =============== END DEBUG LOG ==================
625: --get the total amount for the source budget journal
626: SELECT nvl(sum(dest.budget_amount),0)
627: INTO v_source_amount
628: FROM igi_dos_trx_dest dest
629: WHERE dest.source_trx_id = packet_rec.source_trx_id;
630:
631: -- =============== START DEBUG LOG ================
632: Debug_log_string (l_proc_level, 'Approve.Msg35',

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

983: -- TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;
984: l_packet_data_tab packet_data_type;
985:
986: -- Bug 1635678 sekhar kappaga
987: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
988: IS
989: SELECT *
990: FROM igi_dos_trx_dest
991: WHERE trx_id = l_trx_id

Line 990: FROM igi_dos_trx_dest

986: -- Bug 1635678 sekhar kappaga
987: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
988: IS
989: SELECT *
990: FROM igi_dos_trx_dest
991: WHERE trx_id = l_trx_id
992: AND source_trx_id = p_source_trx_id;
993:
994:

Line 1165: FROM igi_dos_trx_dest dest

1161: -- =============== END DEBUG LOG ==================
1162:
1163: SELECT nvl(sum(dest.budget_amount),0)
1164: INTO v_source_amount
1165: FROM igi_dos_trx_dest dest
1166: WHERE dest.source_trx_id = packet_rec.source_trx_id;
1167:
1168: -- =============== START DEBUG LOG ================
1169: Debug_log_string (l_proc_level, 'Reject.Msg28',