APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_LOOKUP_VALUES

Line 82: select list to fetch meaning from igs_lookup_values

78: remarks :
79: Change History
80: Who When What
81: smadathi 13-nov-2002 Bug 2584986. Modified cursor cur_desc
82: select list to fetch meaning from igs_lookup_values
83: ******************************************************************/
84:
85: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%TYPE, x_code igs_lookups_view.lookup_code%TYPE ) IS
86: SELECT meaning

Line 87: FROM igs_lookup_values

83: ******************************************************************/
84:
85: CURSOR cur_desc( x_type igs_lookups_view.lookup_type%TYPE, x_code igs_lookups_view.lookup_code%TYPE ) IS
86: SELECT meaning
87: FROM igs_lookup_values
88: WHERE lookup_type = x_type
89: AND lookup_code = x_code
90: AND (SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
91: AND NVL(end_date_active,SYSDATE))

Line 189: FROM igs_lookup_values

185:
186:
187: CURSOR c_credit_card_code(cp_meaning VARCHAR2) IS
188: SELECT lookup_code
189: FROM igs_lookup_values
190: WHERE lookup_type = 'IGS_CREDIT_CARDS'
191: AND meaning = ''||cp_meaning||'';
192:
193: CURSOR c_expiration_date(cp_month_year VARCHAR2) IS

Line 197: l_cc_meaning igs_lookup_values.meaning%TYPE;

193: CURSOR c_expiration_date(cp_month_year VARCHAR2) IS
194: SELECT LAST_DAY(TO_DATE('01/' || cp_month_year,'DD/MM/YYYY')) expiry_date
195: FROM dual;
196:
197: l_cc_meaning igs_lookup_values.meaning%TYPE;
198: l_credit_type_id c_credittype_id%ROWTYPE;
199: l_credit_card_code c_credit_card_code%ROWTYPE;
200: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
201: l_expiration_date c_expiration_date%ROWTYPE;