APPS.IGS_FI_GEN_005 dependencies on IGS_AS_SU_SETATMPT

Line 453: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

449: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
450: usft.FEE_TYPE = p_fee_type AND
451: usft.logical_delete_dt IS NULL;
452:
453: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
454: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
455:
456: SELECT 'X'
457: FROM IGS_AS_SU_SETATMPT susa

Line 454: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS

450: usft.FEE_TYPE = p_fee_type AND
451: usft.logical_delete_dt IS NULL;
452:
453: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
454: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
455:
456: SELECT 'X'
457: FROM IGS_AS_SU_SETATMPT susa
458: WHERE susa.person_id = p_person_id AND

Line 457: FROM IGS_AS_SU_SETATMPT susa

453: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
454: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
455:
456: SELECT 'X'
457: FROM IGS_AS_SU_SETATMPT susa
458: WHERE susa.person_id = p_person_id AND
459: susa.course_cd = p_course_cd AND
460: susa.unit_set_cd = cp_unit_set_cd AND
461: susa.us_version_number = cp_version_number AND

Line 576: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

572: uft.version_number = cp_version_number) AND
573: uft.logical_delete_dt IS NULL;
574: CURSOR c_ftg_usft (
575: cp_unit_set_cd
576: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
577: cp_version_number
578: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
579: SELECT usft.unit_set_cd,
580: usft.version_number,

Line 578: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS

574: CURSOR c_ftg_usft (
575: cp_unit_set_cd
576: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
577: cp_version_number
578: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
579: SELECT usft.unit_set_cd,
580: usft.version_number,
581: usft.fee_trigger_group_number
582: FROM IGS_EN_UNITSETFEETRG usft