APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_OR_UNIT_WLST

Line 1739: CURSOR cur_org IS SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst

1735: p_owner_org_unit_cd IN VARCHAR2,
1736: p_cal_type IN VARCHAR2,
1737: p_sequence_number IN NUMBER
1738: ) RETURN NUMBER AS
1739: CURSOR cur_org IS SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst
1740: WHERE org_unit_cd = p_owner_org_unit_cd AND
1741: cal_type = p_cal_type AND
1742: sequence_number = p_sequence_number;
1743: lv_max_stud_per_wlst igs_en_or_unit_wlst.max_stud_per_wlst%TYPE DEFAULT NULL;

Line 1743: lv_max_stud_per_wlst igs_en_or_unit_wlst.max_stud_per_wlst%TYPE DEFAULT NULL;

1739: CURSOR cur_org IS SELECT max_stud_per_wlst FROM igs_en_or_unit_wlst
1740: WHERE org_unit_cd = p_owner_org_unit_cd AND
1741: cal_type = p_cal_type AND
1742: sequence_number = p_sequence_number;
1743: lv_max_stud_per_wlst igs_en_or_unit_wlst.max_stud_per_wlst%TYPE DEFAULT NULL;
1744: BEGIN
1745: OPEN cur_org;
1746: FETCH cur_org INTO lv_max_stud_per_wlst;
1747: IF cur_org%NOTFOUND THEN

Line 2902: l_result igs_en_or_unit_wlst.max_stud_per_wlst%TYPE DEFAULT NULL;

2898: and cal_type=cp_cal_type
2899: and ci_sequence_number=cp_sequence_number
2900: and delete_flag = 'N';
2901:
2902: l_result igs_en_or_unit_wlst.max_stud_per_wlst%TYPE DEFAULT NULL;
2903: BEGIN
2904: OPEN c_check(p_uoo_id);
2905: FETCH c_check INTO l_result;
2906: CLOSE c_check;