[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ca.sca_course_cd,
ca.acai_admission_appl_number,
ca.acai_nominated_course_cd,
ca.acai_sequence_number
FROM IGS_RE_CANDIDATURE ca
WHERE ca.person_id = p_ca_person_id AND
ca.sequence_number = p_ca_sequence_number;
SELECT acai.course_cd,
acai.crv_version_number,
acai.adm_outcome_status
FROM IGS_AD_PS_APPL_INST acai
WHERE acai.person_id = p_ca_person_id AND
acai.admission_appl_number = cp_admin_appl_num AND
acai.nominated_course_cd = cp_nom_course_cd AND
acai.sequence_number = cp_seq_number;
SELECT sca.version_number
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_ca_person_id AND
sca.course_cd = cp_course_cd;
SELECT rsup.start_dt, rsup.end_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number
ORDER BY
rsup.start_dt DESC;
SELECT NVL(SUM(rsup.supervision_percentage),0)
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.start_dt <= cp_date AND
(rsup.end_dt IS NULL OR
rsup.end_dt >= cp_date);
SELECT NVL(SUM(rsup.funding_percentage),0),count(*)
FROM IGS_RE_SPRVSR rsup,
igs_pe_person_types pt,
igs_pe_typ_instances pti
WHERE rsup.ca_person_id = p_ca_person_id
AND rsup.ca_sequence_number = p_ca_sequence_number
AND rsup.person_id = pti.person_id
AND pti.person_type_code = pt.person_type_code
AND pt.system_type = 'STAFF'
AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);
SELECT 'x'
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.start_dt <= cp_start_dt AND
rsup.end_dt IS NOT NULL AND
rsup.end_dt >= cp_start_dt;
SELECT rsup.start_dt,
rsup.end_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number
ORDER BY
rsup.start_dt,
rsup.end_dt;
SELECT MAX(rsup.end_dt)
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number;
SELECT rsup.end_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.end_dt IS NULL;
SELECT rsup.start_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
(p_end_dt IS NULL OR
rsup.start_dt <= p_end_dt) AND
(rsup.end_dt IS NULL OR
rsup.end_dt >= p_start_dt)
ORDER BY rsup.start_dt;
SELECT 'X'
FROM IGS_RE_SPRVSR rsup,
IGS_RE_SPRVSR_TYPE rst
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.start_dt <= cp_start_dt AND
(rsup.end_dt IS NULL OR
rsup.end_dt >= cp_start_dt) AND
rsup.research_supervisor_type = rst.research_supervisor_type AND
rst.principal_supervisor_ind = 'Y';
SELECT rsup.sequence_number,
rsup.end_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.person_id = p_replaced_person_id
ORDER BY rsup.start_dt DESC;
SELECT os.s_org_status, ins.oi_local_institution_ind
FROM igs_or_status os,
igs_or_inst_org_base_v org,
igs_or_inst_org_base_v ins
WHERE org.inst_org_ind = 'O'
AND org.org_status = os.org_status
AND ins.inst_org_ind = 'I'
AND ins.party_number = org.ou_institution_cd
AND org.party_number = p_org_unit_cd
AND org.start_dt = p_ou_start_dt;
SELECT rsup.start_dt,
rsup.end_dt
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.person_id = p_person_id AND
(p_sequence_number IS NULL OR
rsup.sequence_number <> p_sequence_number)
ORDER BY rsup.start_dt desc;
SELECT 'x'
FROM IGS_RE_SPRVSR rsup
WHERE rsup.ca_person_id = p_ca_person_id AND
rsup.ca_sequence_number = p_ca_sequence_number AND
rsup.replaced_person_id = p_person_id AND
rsup.replaced_sequence_number = p_sequence_number AND
(p_end_dt IS NULL OR
rsup.start_dt <= p_end_dt);
SELECT 'x'
FROM IGS_RE_SPRVSR_TYPE rst
WHERE rst.research_supervisor_type = p_research_supervisor_type AND
rst.closed_ind = 'Y';
SELECT start_dt
FROM igs_or_unit
WHERE org_unit_cd = p_org_unit_cd;