APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 82: CURSOR c_org_unit_cd (L_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

78: WHERE grading_schema_cd = l_grading_schema_cd
79: AND version_number = l_version_number
80: and grade = l_grade
81: and s_result_type = 'INCOMP';
82: CURSOR c_org_unit_cd (L_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,

Line 83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;

79: AND version_number = l_version_number
80: and grade = l_grade
81: and s_result_type = 'INCOMP';
82: CURSOR c_org_unit_cd (L_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,

Line 84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;

80: and grade = l_grade
81: and s_result_type = 'INCOMP';
82: CURSOR c_org_unit_cd (L_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
83: SELECT owner_org_unit_cd FROM igs_ps_unit_ofr_opt_all WHERE uoo_id = l_uoo_id;
84: v_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type;
85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,