46: ------------------------------------------------------------------
47: --Created by : Sanil Madathil, Oracle IDC
48: --Date created: 20 Feb 2003
49: --
50: --Purpose: Function to fetch the value of RFND_DESTINATION from IGS_FI_CONTROL
51: --
52: --
53: --
54: --
58: --Who When What
59: ------------------------------------------------------------------
60: CURSOR c_rfnd_destination IS
61: SELECT rfnd_destination
62: FROM igs_fi_control;
63:
64: l_v_rfnd_destination igs_fi_control_all.rfnd_destination%TYPE := NULL;
65:
66: BEGIN
60: CURSOR c_rfnd_destination IS
61: SELECT rfnd_destination
62: FROM igs_fi_control;
63:
64: l_v_rfnd_destination igs_fi_control_all.rfnd_destination%TYPE := NULL;
65:
66: BEGIN
67: --Select the Refund Destination field from the IGS_FI_CONTROL table
68: OPEN c_rfnd_destination;
63:
64: l_v_rfnd_destination igs_fi_control_all.rfnd_destination%TYPE := NULL;
65:
66: BEGIN
67: --Select the Refund Destination field from the IGS_FI_CONTROL table
68: OPEN c_rfnd_destination;
69: FETCH c_rfnd_destination INTO l_v_rfnd_destination;
70: CLOSE c_rfnd_destination;
71: RETURN l_v_rfnd_destination;