DBA Data[Home] [Help]

APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_FI_CR_TYPES

Line 180: CURSOR c_credittype_id(cp_v_credit_class igs_fi_cr_types.credit_class%TYPE) IS

176:
177: masehgal 17-Jan-2002 ENH # 2170429
178: Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
179: ***************************************************************/
180: CURSOR c_credittype_id(cp_v_credit_class igs_fi_cr_types.credit_class%TYPE) IS
181: SELECT credit_type_id , description
182: FROM igs_fi_cr_types
183: WHERE SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date,SYSDATE)
184: AND credit_class = cp_v_credit_class;

Line 182: FROM igs_fi_cr_types

178: Obsoletion of SPONSOR_CD from UPDATE_ROW Call to IGS_FI_INV_INT Tablehandler
179: ***************************************************************/
180: CURSOR c_credittype_id(cp_v_credit_class igs_fi_cr_types.credit_class%TYPE) IS
181: SELECT credit_type_id , description
182: FROM igs_fi_cr_types
183: WHERE SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date,SYSDATE)
184: AND credit_class = cp_v_credit_class;
185:
186: