[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT strty.system_generated_ind
FROM IGS_LOOKUPS_VAL strty
WHERE strty.lookup_code = p_transaction_type AND
strty.lookup_type = 'TRANSACTION_TYPE';
SELECT scas.fee_ass_ind,
std.course_attempt_status
FROM igs_en_spa_terms sca,
igs_en_stdnt_ps_att std,
igs_lookups_view scas
WHERE sca.person_id = p_person_id
AND sca.program_cd = p_course_cd
AND sca.term_cal_type = l_v_load_cal_type
AND sca.term_sequence_number = l_n_load_ci_seq_number
AND sca.person_id = std.person_id
AND sca.program_cd = std.course_cd
AND ((sca.fee_cat IS NULL AND p_fee_cat IS NULL ) OR ( sca.fee_cat = p_fee_cat))
AND scas.lookup_type = 'CRS_ATTEMPT_STATUS'
AND scas.lookup_code = std.course_attempt_status;
SELECT scas.fee_ass_ind,
scaehv.course_attempt_status
FROM IGS_AS_SCAH_EFFECTIVE_H_V scaehv,
IGS_LOOKUPS_VIEW scas
WHERE
scaehv.person_id = p_person_id AND
scaehv.course_cd = p_course_cd AND
((scaehv.fee_cat IS NULL AND
p_fee_cat IS NULL) OR
(scaehv.fee_cat = p_fee_cat)) AND
scas.lookup_type = 'CRS_ATTEMPT_STATUS' AND
TRUNC(p_effective_dt) BETWEEN scaehv.effective_start_dt AND scaehv.effective_end_dt AND
scas.lookup_code = scaehv.course_attempt_status;
SELECT daiv.alias_val
FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
IGS_CA_DA_INST_V daiv
WHERE
fcflv.fee_cal_type = p_fee_cal_type AND
fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
fcflv.fee_type = p_fee_type AND
fcflv.fee_cat = p_fee_cat AND
fcflv.retro_dt_alias = daiv.dt_alias AND
fcflv.retro_dai_sequence_number = daiv.sequence_number AND
fcflv.fee_cal_type = daiv.cal_type AND
fcflv.fee_ci_sequence_number = daiv.ci_sequence_number AND
daiv.alias_val < SYSDATE;
SELECT strty.transaction_cat,
strty.system_generated_ind
FROM IGS_LOOKUPS_VAL strty
WHERE lookup_code = p_transaction_type AND
lookup_type = 'TRANSACTION_TYPE';
SELECT 'X'
FROM IGS_FI_FEE_AS_RT cfar
WHERE cfar.person_id = p_person_id AND
cfar.course_cd = p_course_cd AND
cfar.fee_type = p_fee_type AND
p_effective_dt BETWEEN cfar.start_dt AND
NVL(cfar.end_dt, igs_ge_date.igsdate('9999/01/01'));
SELECT ft.s_fee_trigger_cat
FROM IGS_FI_FEE_TYPE ft
WHERE fee_type = p_fee_type;
SELECT fee_calc_mthd_code
FROM igs_fi_control;
SELECT strty.transaction_cat,
strty.system_generated_ind
FROM IGS_LOOKUPS_VAL strty
WHERE lookup_code = p_transaction_type AND
lookup_type = 'TRANSACTION_TYPE';
SELECT daiv.alias_val
FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
IGS_CA_DA_INST_V daiv
WHERE fcflv.fee_cal_type = p_fee_cal_type AND
fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
fcflv.fee_type = p_fee_type AND
fcflv.fee_cat = nvl(p_fee_cat,fcflv.fee_cat) AND
fcflv.start_dt_alias = daiv.dt_alias AND
fcflv.start_dai_sequence_number = daiv.sequence_number AND
fcflv.fee_cal_type = daiv.cal_type AND
fcflv.fee_ci_sequence_number = daiv.ci_sequence_number;
SELECT daiv.alias_val
FROM IGS_FI_F_CAT_FEE_LBL_V fcflv,
IGS_CA_DA_INST_V daiv
WHERE fcflv.fee_cal_type = p_fee_cal_type AND
fcflv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
fcflv.fee_type = p_fee_type AND
fcflv.fee_cat = nvl(p_fee_cat,fcflv.fee_cat) AND
fcflv.end_dt_alias = daiv.dt_alias AND
fcflv.end_dai_sequence_number = daiv.sequence_number AND
fcflv.fee_cal_type = daiv.cal_type AND
fcflv.fee_ci_sequence_number = daiv.ci_sequence_number;
SELECT strty.transaction_cat
FROM IGS_LOOKUPS_VAL strty
WHERE strty.lookup_code = p_s_transaction_type
AND strty.lookup_type = 'TRANSACTION_TYPE';
|| vvutukur 19-Dec-2002 Bug#2680885.Commented out cursor c_fpv which selects from igs_fi_fee_pay_v, which
|| is to be dropped.Instead, cursor c_fpv is redefined selecting 0 from dual.
|| The datatype for v_total_payments variable is also changed to NUMBER after removing
|| the reference to igs_fi_fee_pay_v.
----------------------------------------------------------------------------*/
gv_other_detail VARCHAR2(255);
SELECT SUM(fadv.transaction_amount)
FROM IGS_FI_FEE_AS fadv
WHERE fadv.person_id = p_person_id
AND fadv.fee_type = p_fee_type
AND fadv.fee_cal_type = p_fee_cal_type
AND fadv.fee_ci_sequence_number = p_fee_ci_sequence_number
AND ((fadv.fee_cat = p_fee_cat) OR(fadv.fee_cat IS NULL AND p_fee_cat IS NULL))
AND ((fadv.course_cd = p_course_cd) OR (fadv.course_cd IS NULL AND p_course_cd IS NULL))
AND fadv.logical_delete_dt IS NULL;
SELECT 0
FROM dual;
SELECT SUM(fpv.payment_amount)
FROM IGS_FI_FEE_PAY_V fpv
WHERE fpv.person_id = p_person_id AND
fpv.fee_type = p_fee_type AND
fpv.fee_cal_type = p_fee_cal_type AND
fpv.fee_ci_sequence_number = p_fee_ci_sequence_number AND
NVL(fpv.fee_cat, 'NULL') = NVL(p_fee_cat, 'NULL') AND
NVL(fpv.course_cd,'NULL') = NVL(p_course_cd,'NULL');*/
p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
p_message_name OUT NOCOPY VARCHAR2 )
RETURN BOOLEAN AS
gv_other_detail VARCHAR2(255);
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
p_message_name := 'IGS_FI_DATA_CANNOT_BE_UPDATED';
IF NVL(p_new_logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))
<> NVL(p_old_logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) AND
p_old_logical_delete_dt IS NOT NULL THEN
p_message_name := 'IGS_FI_LOGDEL_DATE_NOT_CLEAR';