APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_REFUND_SETUP

Line 56: g_amnt_high igs_fi_refund_setup.amount_high%TYPE;

52: g_check_add_drop CONSTANT VARCHAR2(30) := 'CHECK_ADD_DROP';
53: g_yes_no CONSTANT VARCHAR2(30) := 'YES_NO';
54: g_gl_date CONSTANT VARCHAR2(30) := 'GL_DATE';
55:
56: g_amnt_high igs_fi_refund_setup.amount_high%TYPE;
57: g_amnt_low igs_fi_refund_setup.amount_low%TYPE;
58: e_resource_busy EXCEPTION;
59: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);
60:

Line 57: g_amnt_low igs_fi_refund_setup.amount_low%TYPE;

53: g_yes_no CONSTANT VARCHAR2(30) := 'YES_NO';
54: g_gl_date CONSTANT VARCHAR2(30) := 'GL_DATE';
55:
56: g_amnt_high igs_fi_refund_setup.amount_high%TYPE;
57: g_amnt_low igs_fi_refund_setup.amount_low%TYPE;
58: e_resource_busy EXCEPTION;
59: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);
60:
61: -- PL/SQL record for the Credit Information

Line 179: FROM igs_fi_refund_setup

175: -- Select the High and the Low Limits from the refund setup table
176: CURSOR cur_rfnd_limits IS
177: SELECT amount_high,
178: amount_low
179: FROM igs_fi_refund_setup
180: WHERE TRUNC(sysdate) BETWEEN TRUNC(START_DATE) AND TRUNC(NVL(END_DATE,sysdate));
181:
182: l_return BOOLEAN;
183: BEGIN