eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_BREAKDOWN_RPT dependencies on PER_GRADES

Line 310: FROM per_grades GRD

306: IF p_clause = 'GRADE/LEVEL' -- Grade or Level
307: THEN
308: SELECT GDF.segment2
309: INTO l_result
310: FROM per_grades GRD
311: ,per_grade_definitions GDF
312: WHERE GRD.grade_id = p_ASG.grade_id
313: AND GDF.grade_definition_id = GRD.grade_definition_id;
314: ELSIF p_clause = 'OCCODE_PATCOB' -- Occupational Category (PATCOB) Code

Line 334: FROM per_grades GRD

330: ELSIF p_clause = 'GRADE' -- Grade
331: THEN
332: SELECT GRD.name
333: INTO l_result
334: FROM per_grades GRD
335: WHERE GRD.grade_id = p_ASG.grade_id;
336: ELSIF p_clause = 'APPOINTMENT_TYPE' -- Appointment Type
337: THEN
338: l_result := p_PEI_GRP1.pei_information3 || ' - ' ||

Line 429: FROM per_grades GRD

425: ELSIF p_clause = 'PAY_PLAN' -- Pay Plan
426: THEN
427: SELECT GDF.segment1
428: INTO l_result
429: FROM per_grades GRD
430: ,per_grade_definitions GDF
431: WHERE GRD.grade_id = p_ASG.grade_id
432: AND GDF.grade_definition_id = GRD.grade_definition_id;
433: ELSIF p_clause = 'FULL_NAME' THEN