APPS.IGS_PS_VAL_TR dependencies on IGS_PS_TCH_RESP

Line 35: FROM IGS_PS_TCH_RESP

31: UV.version_number = p_version_number AND
32: UV.unit_status= US.unit_status;
33: CURSOR gc_teach_respons_exists IS
34: SELECT 'x'
35: FROM IGS_PS_TCH_RESP
36: WHERE unit_cd = p_unit_cd AND
37: version_number = p_version_number;
38: CURSOR cur_user IS
39: SELECT SUM(percentage)

Line 40: FROM IGS_PS_TCH_RESP

36: WHERE unit_cd = p_unit_cd AND
37: version_number = p_version_number;
38: CURSOR cur_user IS
39: SELECT SUM(percentage)
40: FROM IGS_PS_TCH_RESP
41: WHERE unit_cd = p_unit_cd AND
42: version_number = p_version_number;
43:
44:

Line 45: gv_percent IGS_PS_TCH_RESP.percentage%TYPE;

41: WHERE unit_cd = p_unit_cd AND
42: version_number = p_version_number;
43:
44:
45: gv_percent IGS_PS_TCH_RESP.percentage%TYPE;
46:
47: BEGIN
48: -- finding the s_unit_status
49: OPEN gc_unit_status;

Line 51: -- finding IGS_PS_TCH_RESP records

47: BEGIN
48: -- finding the s_unit_status
49: OPEN gc_unit_status;
50: FETCH gc_unit_status INTO gv_unit_status;
51: -- finding IGS_PS_TCH_RESP records
52: OPEN gc_teach_respons_exists;
53: FETCH gc_teach_respons_exists INTO gv_teach_respons;
54: -- Find the sum of all percentages
55: