DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_GRADES

Line 2657: l_grade_id per_grades.grade_id%type;

2653: l_proc varchar2(72) := g_package||'sf52_from_by_assignment';
2654: l_organization_id hr_organization_units.organization_id%type;
2655: l_position_id per_all_positions.position_id%type;
2656: l_job_id per_jobs.job_id%type;
2657: l_grade_id per_grades.grade_id%type;
2658: l_location_id hr_locations.location_id%type;
2659: l_total_salary number;
2660: l_basic_pay number;
2661: l_locality_adj number;

Line 2769: from per_grades grd,

2765:
2766: cursor c_grade_kff (grd_id number) is
2767: select gdf.segment1,
2768: gdf.segment2
2769: from per_grades grd,
2770: per_grade_definitions gdf
2771: where grd.grade_id = grd_id
2772: and grd.grade_definition_id = gdf.grade_definition_id;
2773: --