DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on PER_GRADES

Line 1019: ,per_grades grd

1015: CURSOR cur_grd IS
1016: SELECT gdf.segment1 pay_plan
1017: ,gdf.segment2 grade_or_level
1018: FROM per_grade_definitions gdf
1019: ,per_grades grd
1020: WHERE grd.grade_id = p_grade_id
1021: AND grd.grade_definition_id = gdf.grade_definition_id;
1022: --
1023: CURSOR cur_org (p_org_id number) IS

Line 2353: FROM per_grades grd

2349: l_valid_grade varchar2(150);
2350: l_grade_id varchar2(150);
2351: CURSOR cur_grd IS
2352: SELECT grd.name grade_name
2353: FROM per_grades grd
2354: WHERE grd.grade_id = TO_NUMBER(l_grade_id);
2355:
2356:
2357: BEGIN