APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_UNIT_STAT

Line 99: FROM igs_ps_unit_stat a,

95:
96: -- Cursor to get system unit status for the unit section.
97: CURSOR c_unit_sts (cp_n_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID%TYPE) IS
98: SELECT a.s_unit_status
99: FROM igs_ps_unit_stat a,
100: igs_ps_unit_ver_all b,
101: igs_ps_unit_ofr_opt_all c
102: WHERE a.unit_status = b.unit_status
103: AND b.unit_cd = c.unit_cd

Line 107: l_c_unit_status IGS_PS_UNIT_STAT.S_UNIT_STATUS%TYPE;

103: AND b.unit_cd = c.unit_cd
104: AND b.version_number = c.version_number
105: AND c.uoo_id = cp_n_uoo_id;
106:
107: l_c_unit_status IGS_PS_UNIT_STAT.S_UNIT_STATUS%TYPE;
108:
109: -- Internal function to get the meaning for the given lookup_type and lookup_code.
110: FUNCTION get_meaning(p_c_lookup_type IN VARCHAR2,
111: p_c_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS