DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PS_UNIT_VER_V

Line 2500: CURSOR cur_chk_cp_chg_val (p_unit_cd igs_ps_unit_ver_v.unit_cd%TYPE,p_unit_ver_num igs_ps_unit_ver_v.version_number%TYPE)

2496: FROM igs_ps_unit_ofr_opt
2497: WHERE uoo_id = p_uoo_id;
2498:
2499: -- Check if the unit is set up for variable cp
2500: CURSOR cur_chk_cp_chg_val (p_unit_cd igs_ps_unit_ver_v.unit_cd%TYPE,p_unit_ver_num igs_ps_unit_ver_v.version_number%TYPE)
2501: IS SELECT points_override_ind
2502: FROM igs_ps_unit_ver_v
2503: WHERE unit_cd = p_unit_cd
2504: AND version_number = p_unit_ver_num;

Line 2502: FROM igs_ps_unit_ver_v

2498:
2499: -- Check if the unit is set up for variable cp
2500: CURSOR cur_chk_cp_chg_val (p_unit_cd igs_ps_unit_ver_v.unit_cd%TYPE,p_unit_ver_num igs_ps_unit_ver_v.version_number%TYPE)
2501: IS SELECT points_override_ind
2502: FROM igs_ps_unit_ver_v
2503: WHERE unit_cd = p_unit_cd
2504: AND version_number = p_unit_ver_num;
2505:
2506: --Check if there exist any user level deadline