APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PR_STDNT_PR_OU

Line 419: FROM igs_pr_stdnt_pr_ou_all

415: cp_prg_ci_sequence_number NUMBER,
416: cp_progression_outcome_type VARCHAR2
417: ) IS
418: SELECT 'X' spo_exists
419: FROM igs_pr_stdnt_pr_ou_all
420: WHERE person_id = cp_person_id
421: AND course_cd = cp_course_cd
422: AND prg_cal_type = cp_prg_cal_type
423: AND prg_ci_sequence_number = cp_prg_ci_sequence_number

Line 526: igs_pr_stdnt_pr_ou_pkg.insert_row (

522: SELECT igs_pr_spo_seq_num_s.NEXTVAL
523: INTO v_spo_sequence_number
524: FROM DUAL;
525: --
526: igs_pr_stdnt_pr_ou_pkg.insert_row (
527: x_rowid => v_rowid,
528: x_person_id => v_person_id,
529: x_course_cd => v_spoi_rec.course_cd,
530: x_sequence_number => v_spo_sequence_number,

Line 853: FROM igs_pr_stdnt_pr_ou spo

849: cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
850: cp_prg_ci_sequence_number igs_ca_inst.sequence_number%TYPE
851: ) IS
852: SELECT 'X'
853: FROM igs_pr_stdnt_pr_ou spo
854: WHERE spo.person_id = cp_person_id
855: AND spo.course_cd = p_course_cd
856: AND spo.progression_outcome_type = p_progression_outcome_type
857: AND spo.decision_status IN ('PENDING', 'APPROVED')