eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_AS_SU_SETATMPT

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

634: usft.fee_cal_type = p_fee_cal_type AND
635: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
636: usft.FEE_TYPE = p_fee_type AND
637: usft.logical_delete_dt IS NULL;
638: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
639: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
640: SELECT 'X'
641: FROM IGS_AS_SU_SETATMPT susa
642: WHERE susa.person_id = p_person_id AND

Line 639: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS

635: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
636: usft.FEE_TYPE = p_fee_type AND
637: usft.logical_delete_dt IS NULL;
638: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
639: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
640: SELECT 'X'
641: FROM IGS_AS_SU_SETATMPT susa
642: WHERE susa.person_id = p_person_id AND
643: susa.course_cd = p_course_cd AND

Line 641: FROM IGS_AS_SU_SETATMPT susa

637: usft.logical_delete_dt IS NULL;
638: CURSOR c_susa (cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
639: cp_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
640: SELECT 'X'
641: FROM IGS_AS_SU_SETATMPT susa
642: WHERE susa.person_id = p_person_id AND
643: susa.course_cd = p_course_cd AND
644: susa.unit_set_cd = cp_unit_set_cd AND
645: susa.us_version_number = cp_version_number AND

Line 746: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

742: uft.version_number = cp_version_number) AND
743: uft.logical_delete_dt IS NULL;
744: CURSOR c_ftg_usft (
745: cp_unit_set_cd
746: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
747: cp_version_number
748: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
749: SELECT usft.unit_set_cd,
750: usft.version_number,

Line 748: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS

744: CURSOR c_ftg_usft (
745: cp_unit_set_cd
746: IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
747: cp_version_number
748: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
749: SELECT usft.unit_set_cd,
750: usft.version_number,
751: usft.fee_trigger_group_number
752: FROM IGS_EN_UNITSETFEETRG usft