APPS.IGS_PR_UPLOAD_EXT_RESULTS dependencies on IGS_PR_ORG_STAT

Line 64: igs_pr_org_stat ost,

60: stty.closed_ind,
61: stty.derivation
62: FROM igs_en_stdnt_ps_att spa,
63: igs_ps_ver pv,
64: igs_pr_org_stat ost,
65: igs_pr_stat_type stty
66: WHERE spa.person_id = cp_person_id
67: AND spa.course_cd = cp_course_cd
68: AND spa.course_cd = pv.course_cd

Line 102: l_stat_timeframe igs_pr_org_stat.timeframe%TYPE;

98: inst_stat_type_rec cur_inst_stat_type%ROWTYPE;
99: stat_ele_rec cur_stat_ele%ROWTYPE;
100: l_stat_closed_ind igs_pr_stat_type.closed_ind%TYPE;
101: l_stat_derivation igs_pr_stat_type.derivation%TYPE;
102: l_stat_timeframe igs_pr_org_stat.timeframe%TYPE;
103: BEGIN
104: IF (igs_ge_gen_004.genp_get_lookup (
105: 'PR_EXTERNAL_STAT_SOURCE',
106: p_stu_acad_stat_int_rec.source_type