APPS.IGS_PS_GEN_001 dependencies on IGS_PS_EXP_WL

Line 4402: FROM igs_ps_exp_wl;

4398:
4399: /* Cursor to get the Calendar Category */
4400: CURSOR c_cal_cat IS
4401: SELECT calendar_cat
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;

Line 4404: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;

4400: CURSOR c_cal_cat IS
4401: SELECT calendar_cat
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 */

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 4583: FROM igs_ps_exp_wl;

4579:
4580: /* Cursor to get the Calendar Category */
4581: CURSOR c_cal_cat IS
4582: SELECT calendar_cat
4583: FROM igs_ps_exp_wl;
4584:
4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;

Line 4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;

4581: CURSOR c_cal_cat IS
4582: SELECT calendar_cat
4583: FROM igs_ps_exp_wl;
4584:
4585: l_c_cal_cat_code igs_ps_exp_wl.calendar_cat%TYPE;
4586: l_c_s_cal_cat igs_ca_type.s_cal_cat%TYPE;
4587: l_c_cal_type igs_ca_inst.cal_type%TYPE;
4588: l_n_cal_seq_num igs_ca_inst.sequence_number%TYPE;
4589: