APPS.IGS_PS_GEN_001 dependencies on IGS_PS_EMP_CATS_WL

Line 4406: l_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE;

4402: FROM igs_ps_exp_wl;
4403:
4404: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4405:
4406: l_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE;
4407:
4408: /* Cursor to get the expected workload for the respective employment category */
4409: CURSOR c_exp_wl(cp_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE,cp_n_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE) IS
4410: SELECT ecw.expected_wl_num

Line 4409: CURSOR c_exp_wl(cp_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE,cp_n_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE) IS

4405:
4406: l_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE;
4407:
4408: /* Cursor to get the expected workload for the respective employment category */
4409: CURSOR c_exp_wl(cp_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE,cp_n_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE) IS
4410: SELECT ecw.expected_wl_num
4411: FROM igs_ps_emp_cats_wl ecw
4412: WHERE ecw.emp_cat_code = cp_c_emp_cat_code AND
4413: cal_cat_code = cp_n_cal_cat_code ORDER BY ecw.last_update_date desc;

Line 4411: FROM igs_ps_emp_cats_wl ecw

4407:
4408: /* Cursor to get the expected workload for the respective employment category */
4409: CURSOR c_exp_wl(cp_c_emp_cat_code igs_ps_emp_cats_wl.emp_cat_code%TYPE,cp_n_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE) IS
4410: SELECT ecw.expected_wl_num
4411: FROM igs_ps_emp_cats_wl ecw
4412: WHERE ecw.emp_cat_code = cp_c_emp_cat_code AND
4413: cal_cat_code = cp_n_cal_cat_code ORDER BY ecw.last_update_date desc;
4414:
4415: l_n_exp_wl igs_ps_emp_cats_wl.expected_wl_num%TYPE:=0;

Line 4415: l_n_exp_wl igs_ps_emp_cats_wl.expected_wl_num%TYPE:=0;

4411: FROM igs_ps_emp_cats_wl ecw
4412: WHERE ecw.emp_cat_code = cp_c_emp_cat_code AND
4413: cal_cat_code = cp_n_cal_cat_code ORDER BY ecw.last_update_date desc;
4414:
4415: l_n_exp_wl igs_ps_emp_cats_wl.expected_wl_num%TYPE:=0;
4416:
4417: /* Cursor to get the override expected workload */
4418: CURSOR c_fac_ovr_wl(cp_n_person_id hz_parties.party_id%TYPE,
4419: cp_c_cal_type igs_ca_inst.cal_type%TYPE,