DBA Data[Home] [Help]

APPS.GHR_BREAKDOWN_RPT dependencies on PER_GRADE_DEFINITIONS

Line 311: ,per_grade_definitions GDF

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
315: THEN

Line 430: ,per_grade_definitions GDF

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
434: SELECT full_name