APPS.IGS_PS_VAL_CALUL dependencies on IGS_PS_UNIT_STAT

Line 42: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

38: p_unit_cd IN VARCHAR2 ,
39: p_version_number IN NUMBER ,
40: p_message_name OUT NOCOPY VARCHAR2 )
41: RETURN BOOLEAN AS
42: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
43: CURSOR c_get_s_unit_status IS
44: SELECT s_unit_status
45: FROM IGS_PS_UNIT_VER,
46: IGS_PS_UNIT_STAT

Line 46: IGS_PS_UNIT_STAT

42: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
43: CURSOR c_get_s_unit_status IS
44: SELECT s_unit_status
45: FROM IGS_PS_UNIT_VER,
46: IGS_PS_UNIT_STAT
47: WHERE unit_cd = p_unit_cd AND
48: version_number = p_version_number AND
49: IGS_PS_UNIT_VER.unit_status = IGS_PS_UNIT_STAT.unit_status;
50: BEGIN

Line 49: IGS_PS_UNIT_VER.unit_status = IGS_PS_UNIT_STAT.unit_status;

45: FROM IGS_PS_UNIT_VER,
46: IGS_PS_UNIT_STAT
47: WHERE unit_cd = p_unit_cd AND
48: version_number = p_version_number AND
49: IGS_PS_UNIT_VER.unit_status = IGS_PS_UNIT_STAT.unit_status;
50: BEGIN
51: p_message_name := NULL;
52: OPEN c_get_s_unit_status;
53: FETCH c_get_s_unit_status INTO v_s_unit_status;