APPS.IGS_FI_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 601: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

597: uft.fee_cal_type = p_fee_cal_type AND
598: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
599: uft.FEE_TYPE = p_fee_type AND
600: uft.logical_delete_dt IS NULL;
601: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
602: cp_version_number
603: IGS_EN_SU_ATTEMPT.version_number%TYPE,
604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number

Line 603: IGS_EN_SU_ATTEMPT.version_number%TYPE,

599: uft.FEE_TYPE = p_fee_type AND
600: uft.logical_delete_dt IS NULL;
601: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
602: cp_version_number
603: IGS_EN_SU_ATTEMPT.version_number%TYPE,
604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number
606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

Line 604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,

600: uft.logical_delete_dt IS NULL;
601: CURSOR c_sua (cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
602: cp_version_number
603: IGS_EN_SU_ATTEMPT.version_number%TYPE,
604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number
606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS

Line 606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

602: cp_version_number
603: IGS_EN_SU_ATTEMPT.version_number%TYPE,
604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number
606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS
609: SELECT 'X'
610: FROM IGS_EN_SU_ATTEMPT sua,

Line 607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

603: IGS_EN_SU_ATTEMPT.version_number%TYPE,
604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number
606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS
609: SELECT 'X'
610: FROM IGS_EN_SU_ATTEMPT sua,
611: IGS_LOOKUPS_view suas

Line 608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS

604: cp_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
605: cp_ci_sequence_number
606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS
609: SELECT 'X'
610: FROM IGS_EN_SU_ATTEMPT sua,
611: IGS_LOOKUPS_view suas
612: WHERE sua.person_id = p_person_id AND

Line 610: FROM IGS_EN_SU_ATTEMPT sua,

606: IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
607: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
608: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE) IS
609: SELECT 'X'
610: FROM IGS_EN_SU_ATTEMPT sua,
611: IGS_LOOKUPS_view suas
612: WHERE sua.person_id = p_person_id AND
613: sua.course_cd = p_course_cd AND
614: sua.unit_cd = cp_unit_cd AND

Line 725: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

721: usft.unit_set_cd = us.unit_set_cd AND
722: usft.version_number = us.version_number;
723:
724: CURSOR c_ftg_uft (
725: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
726: cp_version_number
727: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS
728: SELECT uft.unit_cd,
729: uft.version_number,

Line 727: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS

723:
724: CURSOR c_ftg_uft (
725: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
726: cp_version_number
727: IGS_EN_SU_ATTEMPT.version_number%TYPE)IS
728: SELECT uft.unit_cd,
729: uft.version_number,
730: uft.CAL_TYPE,
731: uft.ci_sequence_number,