APPS.PA_RESOURCE_UTILS dependencies on PER_GRADES

Line 1158: per_grades pg,

1154: select
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

Line 1173: per_grades pg

1169: from
1170: per_valid_grades pvg,
1171: pa_job_relationships pjr,
1172: per_job_groups pjg,
1173: per_grades pg
1174: where
1175: pjg.master_flag = 'Y'
1176: and pjr.from_job_id = P_Job_Id
1177: and pjr.to_job_id = pvg.job_id

Line 1188: per_grades pg

1184: from
1185: per_valid_grades pvg,
1186: pa_job_relationships pjr,
1187: per_job_groups pjg,
1188: per_grades pg
1189: where
1190: pjg.master_flag = 'Y'
1191: and pjr.to_job_id = P_Job_Id
1192: and pjr.from_job_id = pvg.job_id

Line 1201: per_grades pg,

1197: select
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

Line 1212: l_max_seq per_grades.sequence%TYPE := NULL;

1208: from per_job_groups
1209: where master_flag = 'Y')
1210: and trunc(sysdate) between pvg.date_from and nvl(pvg.date_to,trunc(sysdate));*/
1211:
1212: l_max_seq per_grades.sequence%TYPE := NULL;
1213: l_grade_id per_grades.grade_id%TYPE := NULL;
1214: --grades_seq grades_sequences%ROWTYPE;
1215:
1216: BEGIN

Line 1213: l_grade_id per_grades.grade_id%TYPE := NULL;

1209: where master_flag = 'Y')
1210: and trunc(sysdate) between pvg.date_from and nvl(pvg.date_to,trunc(sysdate));*/
1211:
1212: l_max_seq per_grades.sequence%TYPE := NULL;
1213: l_grade_id per_grades.grade_id%TYPE := NULL;
1214: --grades_seq grades_sequences%ROWTYPE;
1215:
1216: BEGIN
1217: /* This function is not used. comment it out. perf bug 4887375