DBA Data[Home] [Help]

APPS.IGS_FI_GEN_APINT dependencies on IGS_FI_CONTROL

Line 50: --Purpose: Function to fetch the value of RFND_DESTINATION from IGS_FI_CONTROL

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: --

Line 62: FROM igs_fi_control;

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

Line 64: l_v_rfnd_destination igs_fi_control_all.rfnd_destination%TYPE := NULL;

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;

Line 67: --Select the Refund Destination field from the IGS_FI_CONTROL table

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;