APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_EN_ORUN_WLST_PRI

Line 1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1128: IS
1129: SELECT owp.org_unit_wlst_pri_id, owp.priority_value, owp.priority_number
1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1131: WHERE ouw.org_unit_cd = cp_org_unit_cd
1132: AND ouw.cal_type = cp_cal_type
1133: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1134: AND ouw.closed_flag = 'N'

Line 1138: CURSOR cur_wlst_org_prf ( cp_priority_id igs_en_orun_wlst_pri.org_unit_wlst_pri_id%TYPE)

1134: AND ouw.closed_flag = 'N'
1135: ORDER BY owp.priority_number;
1136:
1137: -- Cursor to select preferences for a given priority Id at organizational unit level
1138: CURSOR cur_wlst_org_prf ( cp_priority_id igs_en_orun_wlst_pri.org_unit_wlst_pri_id%TYPE)
1139: IS
1140: SELECT preference_code,preference_version
1141: FROM igs_en_orun_wlst_prf
1142: WHERE org_unit_wlst_pri_id = cp_priority_id

Line 1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1146: CURSOR cur_max_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1147: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1148: IS
1149: SELECT count(org_unit_wlst_pri_id)
1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1151: WHERE ouw.org_unit_cd = cp_org_unit_cd
1152: AND ouw.cal_type = cp_cal_type
1153: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1154: AND ouw.closed_flag = 'N';

Line 1164: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1160: IS
1161: SELECT count(org_unit_wlst_prf_id)
1162: FROM igs_en_orun_wlst_prf
1163: WHERE org_unit_wlst_pri_id IN(SELECT owp.org_unit_wlst_pri_id
1164: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1165: WHERE ouw.org_unit_cd = cp_org_unit_cd
1166: AND ouw.cal_type = cp_cal_type
1167: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1168: AND ouw.closed_flag = 'N');