APPS.IGS_PS_VAL_TR dependencies on IGS_PS_UNIT_VER

Line 4: -- Validate teaching responsibility percentage for the IGS_PS_UNIT version

1: PACKAGE BODY IGS_PS_VAL_TR AS
2: /* $Header: IGSPS57B.pls 115.5 2002/12/12 09:48:08 smvk ship $ */
3: --
4: -- Validate teaching responsibility percentage for the IGS_PS_UNIT version
5: FUNCTION crsp_val_tr_perc(
6: p_unit_cd IN VARCHAR2 ,
7: p_version_number IN NUMBER ,
8: p_message_name OUT NOCOPY VARCHAR2,

Line 28: FROM IGS_PS_UNIT_VER UV,

24: gv_teach_respons CHAR;
25: gv_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
26: CURSOR gc_unit_status IS
27: SELECT US.s_unit_status
28: FROM IGS_PS_UNIT_VER UV,
29: IGS_PS_UNIT_STAT US
30: WHERE UV.unit_cd = p_unit_cd AND
31: UV.version_number = p_version_number AND
32: UV.unit_status= US.unit_status;