APPS.IGS_EN_SPAA_LGCY_PUB dependencies on IGS_PS_AWD

Line 96: cp_award_cd igs_ps_awd.award_cd%TYPE,

92: || Who When What
93: || (reverse chronological order - newest change first)
94: */
95: CURSOR cur_awd_grd_sch(
96: cp_award_cd igs_ps_awd.award_cd%TYPE,
97: cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,
98: cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS
99: SELECT 'X'
100: FROM igs_ps_awd

Line 97: cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,

93: || (reverse chronological order - newest change first)
94: */
95: CURSOR cur_awd_grd_sch(
96: cp_award_cd igs_ps_awd.award_cd%TYPE,
97: cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,
98: cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS
99: SELECT 'X'
100: FROM igs_ps_awd
101: WHERE award_cd = cp_award_cd

Line 98: cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS

94: */
95: CURSOR cur_awd_grd_sch(
96: cp_award_cd igs_ps_awd.award_cd%TYPE,
97: cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,
98: cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS
99: SELECT 'X'
100: FROM igs_ps_awd
101: WHERE award_cd = cp_award_cd
102: AND grading_schema_cd = cp_grading_schema_cd

Line 100: FROM igs_ps_awd

96: cp_award_cd igs_ps_awd.award_cd%TYPE,
97: cp_grading_schema_cd igs_ps_awd.grading_schema_cd%TYPE,
98: cp_gs_version_number igs_ps_awd.gs_version_number%TYPE ) IS
99: SELECT 'X'
100: FROM igs_ps_awd
101: WHERE award_cd = cp_award_cd
102: AND grading_schema_cd = cp_grading_schema_cd
103: AND gs_version_number = cp_gs_version_number;
104:

Line 133: IF NOT igs_ps_awd_pkg.get_pk_for_validation (

129: l_ret_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131:
132: -- FK check in the Award Code table
133: IF NOT igs_ps_awd_pkg.get_pk_for_validation (
134: x_award_cd => p_awd_aim_rec.award_cd ) THEN
135: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_NOT_EXIST');
136: FND_MSG_PUB.ADD;
137: l_ret_status := FND_API.G_RET_STS_ERROR;