[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ftci.FEE_TYPE,
ftci.fee_cal_type,
ftci.fee_ci_sequence_number,
ft.s_fee_trigger_cat
FROM IGS_FI_F_TYP_CA_INST ftci,
IGS_FI_FEE_STR_STAT fss,
IGS_FI_FEE_TYPE ft
WHERE (p_fee_type IS NULL OR
ftci.FEE_TYPE = p_fee_type) AND
fss.FEE_STRUCTURE_STATUS = ftci.fee_type_ci_status AND
fss.s_fee_structure_status = cst_active AND
ft.FEE_TYPE = ftci.FEE_TYPE AND
ftci.FEE_TYPE IN
(SELECT FEE_TYPE
FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
IGS_FI_FEE_STR_STAT fss
WHERE fcflv.FEE_CAT = p_fee_cat AND
fcflv.fee_cal_type = ftci.fee_cal_type AND
fcflv.fee_ci_sequence_number = ftci.fee_ci_sequence_number AND
fcflv.FEE_TYPE = ftci.FEE_TYPE AND
fss.FEE_STRUCTURE_STATUS = fcflv.fee_liability_status AND
fss.s_fee_structure_status = cst_active AND
p_effective_dt BETWEEN
IGS_CA_GEN_001.calp_get_alias_val(fcflv.start_dt_alias,
fcflv.start_dai_sequence_number,
ftci.fee_cal_type,
ftci.fee_ci_sequence_number) AND
IGS_CA_GEN_001.calp_get_alias_val(fcflv.end_dt_alias,
fcflv.end_dai_sequence_number,
ftci.fee_cal_type,
ftci.fee_ci_sequence_number));
SELECT 'x'
FROM IGS_LOOKUPS_view scas
WHERE scas.lookup_code = cp_course_attempt_status AND
scas.lookup_type = 'CRS_ATTEMPT_STATUS' AND
scas.fee_ass_ind = 'Y';
SELECT 'x'
FROM IGS_LOOKUPS_view suas
WHERE suas.lookup_code = cp_unit_attempt_status AND
suas.lookup_type = 'UNIT_ATTEMPT_STATUS' AND
suas.fee_ass_ind = 'Y';
SELECT ft.s_fee_trigger_cat
FROM IGS_FI_FEE_TYPE ft
WHERE ft.FEE_TYPE = p_fee_type;
SELECT ctft.COURSE_TYPE
FROM IGS_PS_TYPE_FEE_TRG ctft,
IGS_PS_VER cv
WHERE ctft.FEE_CAT = p_fee_cat AND
ctft.fee_cal_type = p_fee_cal_type AND
ctft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
ctft.FEE_TYPE = p_fee_type AND
cv.course_cd = p_course_cd AND
cv.version_number = p_version_number AND
cv.COURSE_TYPE = ctft.COURSE_TYPE AND
ctft.logical_delete_dt IS NULL;
SELECT cgft.course_group_cd
FROM IGS_PS_GRP_FEE_TRG cgft,
IGS_PS_GRP_MBR cgm
WHERE cgft.FEE_CAT = p_fee_cat AND
cgft.fee_cal_type = p_fee_cal_type AND
cgft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
cgft.FEE_TYPE = p_fee_type AND
cgm.course_cd = p_course_cd AND
cgm.version_number = p_version_number AND
cgm.course_group_cd = cgft.course_group_cd AND
cgft.logical_delete_dt IS NULL;
SELECT cft.fee_trigger_group_number
FROM IGS_PS_FEE_TRG cft
WHERE cft.FEE_CAT = p_fee_cat AND
cft.fee_cal_type = p_fee_cal_type AND
cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
cft.FEE_TYPE = p_fee_type AND
cft.course_cd = p_course_cd AND
(cft.version_number IS NULL OR
cft.version_number = p_version_number) AND
p_cal_type LIKE NVL(cft.CAL_TYPE, '%') AND
p_location_cd LIKE NVL(cft.location_cd, '%') AND
p_attendance_mode LIKE NVL(cft.ATTENDANCE_MODE, '%') AND
p_attendance_type LIKE NVL(cft.ATTENDANCE_TYPE, '%') AND
cft.logical_delete_dt IS NULL;
SELECT uft.unit_cd,
uft.version_number,
uft.CAL_TYPE,
uft.ci_sequence_number,
uft.location_cd,
uft.UNIT_CLASS,
uft.fee_trigger_group_number
FROM IGS_FI_UNIT_FEE_TRG uft
WHERE uft.FEE_CAT = p_fee_cat AND
uft.fee_cal_type = p_fee_cal_type AND
uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
uft.FEE_TYPE = p_fee_type AND
uft.logical_delete_dt IS NULL;
SELECT 'X'
FROM IGS_EN_SU_ATTEMPT sua,
IGS_LOOKUPS_view suas
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
( sua.unit_cd = cp_unit_cd OR cp_unit_cd IS NULL) AND
(cp_version_number IS NULL OR
sua.version_number = cp_version_number) AND
(cp_cal_type IS NULL OR
sua.CAL_TYPE = cp_cal_type) AND
(cp_ci_sequence_number IS NULL OR
sua.ci_sequence_number = cp_ci_sequence_number) AND
(cp_location_cd IS NULL OR
sua.location_cd = cp_location_cd) AND
(cp_unit_class IS NULL OR
sua.UNIT_CLASS = cp_unit_class) AND
suas.lookup_code = sua.unit_attempt_status AND
suas.lookup_type = g_v_sua_status AND
suas.fee_ass_ind = g_v_yes AND
( ( sua.no_assessment_ind = g_v_yes AND
cp_v_audit_only = g_v_yes
)
OR cp_v_audit_only = g_v_no
);
SELECT usft.unit_set_cd,
usft.version_number,
usft.fee_trigger_group_number
FROM IGS_EN_UNITSETFEETRG usft
WHERE usft.FEE_CAT = p_fee_cat AND
usft.fee_cal_type = p_fee_cal_type AND
usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
usft.FEE_TYPE = p_fee_type AND
usft.logical_delete_dt IS NULL;
SELECT 'X'
FROM IGS_AS_SU_SETATMPT susa
WHERE susa.person_id = p_person_id AND
susa.course_cd = p_course_cd AND
susa.unit_set_cd = cp_unit_set_cd AND
susa.us_version_number = cp_version_number AND
susa.student_confirmed_ind = g_v_yes AND
(susa.selection_dt IS NOT NULL AND
TRUNC(p_effective_dt) >= TRUNC(susa.selection_dt)) AND
(susa.end_dt IS NULL OR
TRUNC(p_effective_dt) <= TRUNC(susa.end_dt)) AND
(susa.rqrmnts_complete_dt IS NULL OR
TRUNC(p_effective_dt) <= TRUNC(susa.rqrmnts_complete_dt));
SELECT 'X'
FROM igs_en_su_attempt sua,
igs_lookups_view suas
WHERE sua.person_id = p_person_id
AND sua.course_cd = p_course_cd
AND suas.lookup_type = g_v_sua_status
AND suas.lookup_code = sua.unit_attempt_status
AND suas.fee_ass_ind = g_v_yes
AND sua.no_assessment_ind = g_v_yes;
SELECT lkp.lookup_code trigger_type_code,
cft.course_cd code,
cft.version_number
FROM IGS_PS_FEE_TRG cft,
IGS_PS_VER crv,
IGS_LOOKUP_VALUES lkp
WHERE cft.FEE_CAT = p_fee_cat AND
cft.fee_cal_type = p_fee_cal_type AND
cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
cft.FEE_TYPE = p_fee_type AND
cft.fee_trigger_group_number = p_fee_trigger_group_number AND
lkp.lookup_type = 'IGS_FI_TRIGGER_GROUP' AND
lkp.lookup_code = 'COURSE' AND
cft.fee_trigger_group_number IS NOT NULL AND
cft.logical_delete_dt IS NULL AND
cft.course_cd = crv.course_cd AND
(cft.version_number = crv.version_number OR
(cft.version_number IS NULL AND
crv.version_number = ( SELECT MAX(crv2.version_number)
FROM IGS_PS_VER crv2
WHERE crv2.course_cd = crv.course_cd)));
SELECT lkp.lookup_code trigger_type_code,
uft.unit_cd code,
uft.version_number
FROM IGS_FI_UNIT_FEE_TRG uft,
IGS_PS_UNIT_VER uv,
IGS_LOOKUP_VALUES lkp
WHERE uft.FEE_CAT = p_fee_cat AND
uft.fee_cal_type = p_fee_cal_type AND
uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
uft.FEE_TYPE = p_fee_type AND
uft.fee_trigger_group_number = p_fee_trigger_group_number AND
lkp.lookup_type = 'IGS_FI_TRIGGER_GROUP' AND
lkp.lookup_code = 'UNIT' AND
uft.fee_trigger_group_number IS NOT NULL AND
uft.logical_delete_dt IS NULL AND
uft.unit_cd = uv.unit_cd AND
(uft.version_number = uv.version_number OR
(uft.version_number IS NULL AND
uv.version_number = ( SELECT MAX(uv2.version_number)
FROM IGS_PS_UNIT_VER uv2
WHERE uv2.unit_cd = uv.unit_cd)));
SELECT usft.unit_set_cd code, usft.version_number,
lkp.lookup_code trigger_type_code
FROM IGS_EN_UNITSETFEETRG usft,
IGS_EN_UNIT_SET us,
IGS_LOOKUP_VALUES lkp
WHERE usft.FEE_CAT = p_fee_cat AND
usft.fee_cal_type = p_fee_cal_type AND
usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
usft.FEE_TYPE = p_fee_type AND
usft.fee_trigger_group_number = p_fee_trigger_group_number AND
lkp.lookup_type = 'IGS_FI_TRIGGER_GROUP' AND
lkp.lookup_code = 'UNITSET' AND
usft.fee_trigger_group_number IS NOT NULL AND
usft.logical_delete_dt IS NULL AND
usft.unit_set_cd = us.unit_set_cd AND
usft.version_number = us.version_number;
SELECT uft.unit_cd,
uft.version_number,
uft.CAL_TYPE,
uft.ci_sequence_number,
uft.location_cd,
uft.UNIT_CLASS,
uft.fee_trigger_group_number
FROM IGS_FI_UNIT_FEE_TRG uft
WHERE uft.FEE_CAT = p_fee_cat AND
uft.fee_cal_type = p_fee_cal_type AND
uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
uft.FEE_TYPE = p_fee_type AND
uft.unit_cd = cp_unit_cd AND
(uft.version_number IS NULL OR
uft.version_number = cp_version_number) AND
uft.logical_delete_dt IS NULL;
SELECT usft.unit_set_cd,
usft.version_number,
usft.fee_trigger_group_number
FROM IGS_EN_UNITSETFEETRG usft
WHERE usft.FEE_CAT = p_fee_cat AND
usft.fee_cal_type = p_fee_cal_type AND
usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
usft.FEE_TYPE = p_fee_type AND
usft.unit_set_cd = cp_unit_set_cd AND
usft.version_number = cp_version_number AND
usft.logical_delete_dt IS NULL;
SELECT rec_installed
FROM igs_fi_control;
SELECT manage_accounts,accounting_method
FROM igs_fi_control;
SELECT group_cd
FROM igs_pe_persid_group
WHERE group_id = cp_n_group_id;