APPS.PA_RESOURCE_UTILS dependencies on PER_VALID_GRADES

Line 1149: RETURN per_valid_grades.grade_id%type

1145:
1146:
1147: FUNCTION GetValJobGradeId (P_Job_Id IN per_jobs.job_id%TYPE,
1148: P_Job_Grp_Id IN per_jobs.job_group_id%TYPE)
1149: RETURN per_valid_grades.grade_id%type
1150:
1151: IS
1152:
1153: /*CURSOR grades_sequences is -- commented out for perf bug 4887375

Line 1159: per_valid_grades pvg

1155: distinct pg.grade_id,pg.sequence
1156: from
1157: per_job_groups pjg,
1158: per_grades pg,
1159: per_valid_grades pvg
1160: where
1161: pjg.master_flag = 'Y'
1162: and pjg.job_group_id = P_Job_Grp_Id
1163: and pvg.job_id = P_Job_Id

Line 1170: per_valid_grades pvg,

1166: UNION
1167: select
1168: distinct pg.grade_id,pg.sequence
1169: from
1170: per_valid_grades pvg,
1171: pa_job_relationships pjr,
1172: per_job_groups pjg,
1173: per_grades pg
1174: where

Line 1185: per_valid_grades pvg,

1181: UNION
1182: select
1183: distinct pg.grade_id,pg.sequence
1184: from
1185: per_valid_grades pvg,
1186: pa_job_relationships pjr,
1187: per_job_groups pjg,
1188: per_grades pg
1189: where

Line 1202: per_valid_grades pvg

1198: distinct pg.grade_id,pg.sequence
1199: from
1200: per_job_groups pjg,
1201: per_grades pg,
1202: per_valid_grades pvg
1203: where pjg.master_flag = 'N'
1204: and pjg.job_group_id = P_Job_Grp_Id
1205: and pvg.job_id = P_Job_Id
1206: and pg.grade_id = pvg.grade_id