[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT student_plan_id,
payment_plan_name
FROM igs_fi_pp_std_attrs
WHERE person_id = p_n_person_id
AND plan_status_code = 'ACTIVE';
SELECT SUM(due_amt)
FROM igs_fi_pp_instlmnts
WHERE student_plan_id = cp_n_act_plan_id
AND ((TRUNC(due_date) <= TRUNC(cp_d_effective_date)) OR (cp_d_effective_date IS NULL));
SELECT party_number
FROM hz_parties
WHERE party_id = cp_n_party_id;
SELECT invoice_number
FROM igs_fi_inv_int
WHERE invoice_id = cp_v_invoice_id;
SELECT inv.invoice_number
FROM igs_fi_inv_int inv
WHERE inv.invoice_id=cp_invoice_id
AND (inv.optional_fee_flag = g_v_opt_fee_decl OR inv.waiver_flag = g_v_waiver_yes);
SELECT inv.invoice_number
FROM igs_fi_inv_int inv,
igs_fi_invln_int invln
WHERE inv.person_id=cp_person_id
AND invln.invoice_id=inv.invoice_id
AND inv.fee_cal_type=cp_fee_cal_type
AND (inv.fee_cat = cp_fee_cat OR (inv.fee_cat IS NULL AND cp_fee_cat IS NULL))
AND inv.fee_type = cp_fee_type
AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number
AND (inv.course_cd=cp_course_cd OR (inv.course_cd IS NULL AND cp_course_cd IS NULL))
AND (invln.location_cd = cp_location_cd OR (invln.location_cd IS NULL AND cp_location_cd IS NULL))
AND NVL(invln.uoo_id,0) = NVL(cp_uoo_id,0)
AND inv.transaction_type = cp_transaction_type
AND (inv.optional_fee_flag = g_v_opt_fee_decl OR inv.waiver_flag = g_v_waiver_yes);
SELECT retention_level_code,
NVL(complete_ret_flag,'N')
FROM igs_fi_f_typ_ca_inst
WHERE fee_type = cp_v_fee_type
AND fee_cal_type = cp_v_fee_cal_type
AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num;
SELECT *
FROM igs_fi_tp_ret_schd_v
WHERE teach_cal_type = cp_v_teach_cal_type
AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
AND fee_cal_type = cp_v_fee_cal_type
AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num
AND fee_type = cp_v_fee_type
ORDER BY dai_alias_val;
SELECT *
FROM igs_fi_tp_ret_schd_v
WHERE teach_cal_type = cp_v_teach_cal_type
AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
AND fee_type IS NULL
AND fee_cal_type IS NULL
AND fee_ci_sequence_number IS NULL
ORDER BY dai_alias_val;
SELECT retention_percentage,
retention_amount
FROM igs_fi_fee_ret_schd_f_type_v
WHERE fee_type = cp_v_fee_type
AND fee_cal_type = cp_v_fee_cal_type
AND fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND ( (fee_cat = cp_v_fee_cat) OR (fee_cat IS NULL) )
AND ( (TRUNC(SYSDATE) >= TRUNC(start_dt)) OR (start_dt IS NULL) )
AND ( (TRUNC(SYSDATE) <= TRUNC(end_dt)) OR (end_dt IS NULL) )
ORDER BY start_dt;
SELECT retention_percentage,
retention_amount
FROM igs_fi_fee_ret_schd_v
WHERE fee_type = cp_v_fee_type
AND fee_cal_type = cp_v_fee_cal_type
AND fee_ci_sequence_number = cp_n_fee_ci_sequence_number
AND s_relation_type = cp_v_relation_ftci
AND ( (TRUNC(SYSDATE) >= TRUNC(start_dt)) OR start_dt IS NULL)
AND ( (TRUNC(SYSDATE) <= TRUNC(end_dt)) OR end_dt IS NULL)
ORDER BY start_dt;
SELECT s_fee_type
FROM igs_fi_fee_type
WHERE fee_type = cp_v_fee_type;
SELECT sua.*, usec.non_std_usec_ind
FROM igs_en_su_attempt sua,
igs_ps_unit_ofr_opt usec
WHERE sua.person_id = cp_n_person_id
AND sua.course_cd = cp_v_course_cd
AND usec.uoo_id = sua.uoo_id
AND sua.unit_attempt_status NOT IN ('INVALID','DUPLICATE')
AND ( (NVL(cp_v_nz_billable_cp_flag,'N') = 'Y' AND igs_fi_prc_fee_ass.finpl_clc_sua_cp( sua.unit_cd,
sua.version_number,
sua.cal_type,
sua.ci_sequence_number,
cp_v_load_cal_type,
cp_n_load_ci_seq_num,
sua.override_enrolled_cp,
sua.override_eftsu,
sua.uoo_id,
sua.no_assessment_ind) <> 0)
OR NVL(cp_v_nz_billable_cp_flag,'N') = 'N' )
AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N');
SELECT 'X'
FROM igs_fi_tp_ret_schd_v
WHERE teach_cal_type = cp_v_teach_cal_type
AND teach_ci_sequence_number = cp_n_teach_ci_seq_num
AND fee_type IS NULL
AND fee_cal_type IS NULL
AND fee_ci_sequence_number IS NULL
AND TRUNC(dai_alias_val) <= TRUNC(cp_d_disc_dt);
SELECT dtl.offset_date
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id = cp_n_uoo_id
AND rtn.fee_type = cp_v_fee_type
ORDER BY dtl.offset_date;
SELECT dtl.offset_date
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id = cp_n_uoo_id
AND rtn.fee_type IS NULL
ORDER BY dtl.offset_date;
SELECT igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,
rtn.formula_method,
rtn.round_method,
rtn.incl_wkend_duration_flag,
dtl.offset_value) offset_date
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id IS NULL
AND rtn.fee_type IS NULL
ORDER BY offset_date;
SELECT dtl.offset_date,
dtl.retention_amount,
dtl.retention_percent
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id = cp_n_uoo_id
AND rtn.fee_type = cp_v_fee_type
ORDER BY offset_date;
SELECT dtl.offset_date,
dtl.retention_amount,
dtl.retention_percent
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id = cp_n_uoo_id
AND rtn.fee_type IS NULL
ORDER BY offset_date;
SELECT dtl.retention_amount,
dtl.retention_percent,
igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,
rtn.formula_method,
rtn.round_method,
rtn.incl_wkend_duration_flag,
dtl.offset_value) offset_date
FROM igs_ps_nsus_rtn_dtl dtl,
igs_ps_nsus_rtn rtn
WHERE rtn.non_std_usec_rtn_id = dtl.non_std_usec_rtn_id
AND rtn.uoo_id IS NULL
AND rtn.fee_type IS NULL
ORDER BY offset_date;
ns_usec_retention_tbl.DELETE;
SELECT cal_type,
ci_sequence_number,
non_std_usec_ind
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_n_uoo_id;
SELECT standard_balance
FROM igs_fi_balances
WHERE party_id = cp_partyid
ORDER BY balance_date DESC;
SELECT 'x'
FROM igs_fi_fee_as_all
WHERE person_id = cp_n_person_id
AND ((course_cd = cp_v_course_cd OR course_cd IS NULL))
AND fee_cal_type = cp_v_fee_cal_type
AND fee_ci_sequence_number = cp_n_fee_ci_seq
AND s_transaction_type = 'ASSESSMENT';
SELECT 'x'
FROM igs_fi_f_cat_fee_lbl_all lbl,
igs_fi_fee_as_rt rt
WHERE lbl.fee_type = rt.fee_type
AND rt.person_id = cp_n_person_id
AND rt.course_cd = cp_v_course_cd
AND lbl.fee_cat = cp_v_fee_cat
AND TRUNC(SYSDATE) BETWEEN TRUNC(rt.start_dt) AND TRUNC(NVL(rt.end_dt,SYSDATE));
SELECT DECODE( NVL(FND_PROFILE.VALUE('IGS_FI_MASK_CREDIT_CARD_NUMBERS'),'F'),
'N', p_credit_card,
'F', RPAD( SUBSTR(p_credit_card,1,4),LENGTH(p_credit_card),'*'),
'L', LPAD( SUBSTR(p_credit_card,-4),LENGTH(p_credit_card),'*')
)
FROM dual;
SELECT 'x'
FROM igs_en_dcnt_reasoncd
WHERE s_discontinuation_reason_type = 'UNIT_TRANS'
AND discontinuation_reason_cd = cp_v_disc_reason_cd;