APPS.IGS_PS_GEN_001 dependencies on HZ_PARTIES

Line 4418: CURSOR c_fac_ovr_wl(cp_n_person_id hz_parties.party_id%TYPE,

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,
4420: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4421: ) IS
4422: SELECT NVL(fow.new_exp_wl,0)

Line 4433: CURSOR c_fac_assign_wl(cp_n_person_id hz_parties.party_id%TYPE,

4429:
4430: l_n_fac_ovr_wl igs_ps_fac_ovr_wl.new_exp_wl%TYPE:=0;
4431:
4432: /* Cursor to get sum of workload from assigned workload */
4433: CURSOR c_fac_assign_wl(cp_n_person_id hz_parties.party_id%TYPE,
4434: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4435: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4436: ) IS
4437: SELECT NVL(SUM(NVL(fat.default_wl,0)),0)

Line 4448: CURSOR c_tch_resp_wl(cp_n_person_id hz_parties.party_id%TYPE,

4444:
4445: l_n_fac_assign_wl NUMBER:=0;
4446:
4447: /* Cursor to get sum of workload from Unit Section Teaching Responsibility */
4448: CURSOR c_tch_resp_wl(cp_n_person_id hz_parties.party_id%TYPE,
4449: cp_c_cal_type igs_ca_inst.cal_type%TYPE,
4450: cp_n_cal_seq_num igs_ca_inst.sequence_number%TYPE
4451: )IS
4452: SELECT NVL(utr.INSTRUCTIONAL_LOAD_LAB,0) +