APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_TYPE

Line 360: IGS_PR_OU_TYPE pot,

356: sca.commencement_dt,
357: sca.course_attempt_status,
358: sca.discontinuation_reason_cd
359: FROM IGS_PR_STDNT_PR_OU spo,
360: IGS_PR_OU_TYPE pot,
361: IGS_EN_STDNT_PS_ATT sca,
362: IGS_PS_VER crv
363: WHERE (
364: p_spo_person_id IS NULL

Line 528: IGS_PR_OU_TYPE pot

524: SELECT /*+INDEX(spo spo_pk)*/
525: spo.sequence_number,
526: spo.expiry_dt
527: FROM IGS_PR_STDNT_PR_OU spo,
528: IGS_PR_OU_TYPE pot
529: WHERE
530: (EXISTS (
531: SELECT 'X'
532: FROM IGS_PR_STDNT_PR_PS spc

Line 3597: IGS_PR_OU_TYPE.progression_outcome_type%TYPE,

3593: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
3594: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
3595: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE,
3596: p_progression_outcome_type
3597: IGS_PR_OU_TYPE.progression_outcome_type%TYPE,
3598: p_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE)
3599: IS
3600: BEGIN -- prgpl_ins_log_entry
3601: -- create a log entry

Line 3723: FROM IGS_PR_OU_TYPE pot,

3719: poc.pra_sequence_number = p_original_pra_sequence_number AND
3720: poc.pro_sequence_number = p_pro_sequence_number;
3721: CURSOR c_pot_etde IS
3722: SELECT 'X'
3723: FROM IGS_PR_OU_TYPE pot,
3724: IGS_FI_ENC_DFLT_EFT etde
3725: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
3726: pot.s_progression_outcome_type IN (
3727: cst_suspension,

Line 4323: IGS_PR_OU_TYPE.progression_outcome_type%TYPE;

4319: cst_removed CONSTANT VARCHAR2(10) := 'REMOVED';
4320: cst_spo CONSTANT VARCHAR2(10) := 'SPO';
4321: v_record_locked BOOLEAN DEFAULT FALSE;
4322: v_progression_outcome_type
4323: IGS_PR_OU_TYPE.progression_outcome_type%TYPE;
4324: CURSOR c_spo IS
4325: SELECT spo.*,
4326: spo.ROWID
4327: FROM IGS_PR_STDNT_PR_OU spo

Line 6340: IGS_PR_OU_TYPE pot

6336: spo.course_cd,
6337: spo.sequence_number,
6338: spo.expiry_dt
6339: FROM IGS_PR_STDNT_PR_OU spo,
6340: IGS_PR_OU_TYPE pot
6341: WHERE spo.decision_status = cst_approved AND
6342: spo.applied_dt IS NOT NULL AND
6343: spo.expiry_dt IS NULL AND
6344: spo.duration IS NOT NULL AND

Line 6372: IGS_PR_OU_TYPE pot

6368: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6369: EXISTS (
6370: SELECT 'X'
6371: FROM IGS_PR_STDNT_PR_OU spo,
6372: IGS_PR_OU_TYPE pot
6373: WHERE pot.progression_outcome_type = spo.progression_outcome_type AND
6374: spo.person_id = sca.person_id AND
6375: spo.course_cd = sca.course_cd AND
6376: ((spo.decision_status = cst_pending AND

Line 6449: IGS_PR_OU_TYPE pot

6445: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6446: NOT EXISTS (
6447: SELECT 'X'
6448: FROM IGS_PR_STDNT_PR_OU spo,
6449: IGS_PR_OU_TYPE pot
6450: WHERE pot.progression_outcome_type = spo.progression_outcome_type AND
6451: spo.person_id = sca.person_id AND
6452: spo.course_cd = sca.course_cd AND
6453: spo.decision_status = cst_approved AND