APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AS_GRD_SCHEMA

Line 1033: FROM igs_as_grd_schema

1029: -- to get grading schema description
1030: CURSOR c_grd_desc(cp_grd_schm IN VARCHAR2,
1031: cp_ver_num IN NUMBER) IS
1032: SELECT description
1033: FROM igs_as_grd_schema
1034: WHERE grading_schema_cd = cp_grd_schm
1035: AND version_number = cp_ver_num;
1036:
1037: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;

Line 1037: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;

1033: FROM igs_as_grd_schema
1034: WHERE grading_schema_cd = cp_grd_schm
1035: AND version_number = cp_ver_num;
1036:
1037: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;
1038: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;
1039: l_grd_desc igs_as_grd_schema.description%TYPE;
1040:
1041: BEGIN

Line 1038: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;

1034: WHERE grading_schema_cd = cp_grd_schm
1035: AND version_number = cp_ver_num;
1036:
1037: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;
1038: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;
1039: l_grd_desc igs_as_grd_schema.description%TYPE;
1040:
1041: BEGIN
1042:

Line 1039: l_grd_desc igs_as_grd_schema.description%TYPE;

1035: AND version_number = cp_ver_num;
1036:
1037: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;
1038: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;
1039: l_grd_desc igs_as_grd_schema.description%TYPE;
1040:
1041: BEGIN
1042:
1043: -- Get the grading schema code and version from SUA level.

Line 1121: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;

1117: uvgr.unit_code = cp_c_unit_cd AND
1118: uvgr.unit_version_number = cp_n_ver_num AND
1119: uvgr.default_flag = 'Y';
1120:
1121: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;
1122: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;
1123:
1124: BEGIN
1125:

Line 1122: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;

1118: uvgr.unit_version_number = cp_n_ver_num AND
1119: uvgr.default_flag = 'Y';
1120:
1121: l_grd_schm igs_as_grd_schema.grading_schema_cd%TYPE;
1122: l_grd_schm_ver igs_as_grd_schema.version_number%TYPE;
1123:
1124: BEGIN
1125:
1126: -- Get the grading schema code and version from SUA level.