APPS.PA_RESOURCE_UTILS dependencies on PER_GRADES

Line 1079: per_grades pg,

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

Line 1094: per_grades pg

1090: from
1091: per_valid_grades pvg,
1092: pa_job_relationships pjr,
1093: per_job_groups pjg,
1094: per_grades pg
1095: where
1096: pjg.master_flag = 'Y'
1097: and pjr.from_job_id = P_Job_Id
1098: and pjr.to_job_id = pvg.job_id

Line 1109: per_grades pg

1105: from
1106: per_valid_grades pvg,
1107: pa_job_relationships pjr,
1108: per_job_groups pjg,
1109: per_grades pg
1110: where
1111: pjg.master_flag = 'Y'
1112: and pjr.to_job_id = P_Job_Id
1113: and pjr.from_job_id = pvg.job_id

Line 1122: per_grades pg,

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

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

1129: from per_job_groups
1130: where master_flag = 'Y')
1131: and trunc(sysdate) between pvg.date_from and nvl(pvg.date_to,trunc(sysdate));*/
1132:
1133: l_max_seq per_grades.sequence%TYPE := NULL;
1134: l_grade_id per_grades.grade_id%TYPE := NULL;
1135: --grades_seq grades_sequences%ROWTYPE;
1136:
1137: BEGIN

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

1130: where master_flag = 'Y')
1131: and trunc(sysdate) between pvg.date_from and nvl(pvg.date_to,trunc(sysdate));*/
1132:
1133: l_max_seq per_grades.sequence%TYPE := NULL;
1134: l_grade_id per_grades.grade_id%TYPE := NULL;
1135: --grades_seq grades_sequences%ROWTYPE;
1136:
1137: BEGIN
1138: /* This function is not used. comment it out. perf bug 4887375