DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_PS_UNIT_VER_V

Line 1716: 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)

1712: FROM igs_ps_unit_ofr_opt
1713: WHERE uoo_id = p_uoo_id;
1714:
1715: -- Check if the unit is set up for variable cp
1716: 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)
1717: IS SELECT points_override_ind
1718: FROM igs_ps_unit_ver_v
1719: WHERE unit_cd = p_unit_cd
1720: AND version_number = p_unit_ver_num;

Line 1718: FROM igs_ps_unit_ver_v

1714:
1715: -- Check if the unit is set up for variable cp
1716: 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)
1717: IS SELECT points_override_ind
1718: FROM igs_ps_unit_ver_v
1719: WHERE unit_cd = p_unit_cd
1720: AND version_number = p_unit_ver_num;
1721:
1722: --Check if there exist any user level deadline