DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_PS_FEE_TRG

Line 574: FROM IGS_PS_FEE_TRG cft

570: cgm.course_group_cd = cgft.course_group_cd AND
571: cgft.logical_delete_dt IS NULL;
572: CURSOR c_cft IS
573: SELECT cft.fee_trigger_group_number
574: FROM IGS_PS_FEE_TRG cft
575: WHERE cft.FEE_CAT = p_fee_cat AND
576: cft.fee_cal_type = p_fee_cal_type AND
577: cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
578: cft.FEE_TYPE = p_fee_type AND

Line 666: FROM IGS_PS_FEE_TRG cft,

662: CURSOR c_ftgv_course IS
663: SELECT lkp.lookup_code trigger_type_code,
664: cft.course_cd code,
665: cft.version_number
666: FROM IGS_PS_FEE_TRG cft,
667: IGS_PS_VER crv,
668: IGS_LOOKUP_VALUES lkp
669: WHERE cft.FEE_CAT = p_fee_cat AND
670: cft.fee_cal_type = p_fee_cal_type AND