1066:
1067:
1068: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1069: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1070: RETURN per_valid_grades.grade_id%type
1071:
1072: IS
1073:
1074: /*CURSOR grades_sequences is -- commented out for perf bug 4887375
1076: distinct pg.grade_id,pg.sequence
1077: from
1078: per_job_groups pjg,
1079: per_grades pg,
1080: per_valid_grades pvg
1081: where
1082: pjg.master_flag = 'Y'
1083: and pjg.job_group_id = P_Job_Grp_Id
1084: and pvg.job_id = P_Job_Id
1087: UNION
1088: select
1089: distinct pg.grade_id,pg.sequence
1090: from
1091: per_valid_grades pvg,
1092: pa_job_relationships pjr,
1093: per_job_groups pjg,
1094: per_grades pg
1095: where
1102: UNION
1103: select
1104: distinct pg.grade_id,pg.sequence
1105: from
1106: per_valid_grades pvg,
1107: pa_job_relationships pjr,
1108: per_job_groups pjg,
1109: per_grades pg
1110: where
1119: distinct pg.grade_id,pg.sequence
1120: from
1121: per_job_groups pjg,
1122: per_grades pg,
1123: per_valid_grades pvg
1124: where pjg.master_flag = 'N'
1125: and pjg.job_group_id = P_Job_Grp_Id
1126: and pvg.job_id = P_Job_Id
1127: and pg.grade_id = pvg.grade_id