[Home] [Help]
133:
134: g_cat_Enc_Diff_table t_E_differential;
135: g_lev_Enc_Diff_table t_E_differential;
136:
137: g_grade_name per_grades.name%type;
138: g_grade_report_date date;
139: g_grade_asg_id per_all_assignments_f.assignment_id%type;
140:
141: g_position_name per_all_positions.name%type;
1361:
1362: begin
1363: if p_grade_id is not null then
1364:
1365: l_sql := 'select decode(flv1.attribute1,null,flv1.meaning, flv2.meaning) from fnd_lookup_values flv1, fnd_lookup_values flv2, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
1366: || to_char(p_grade_id)
1367: || ' and pgd.grade_definition_id = pg.grade_definition_id '
1368: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1369: || ' and flv1.lookup_code = pgd.' || p_segment
1514: elsif p_flex = 'Grade' then
1515:
1516: begin
1517: if p_grade_id is not null then
1518: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
1519: || to_char(p_grade_id)
1520: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1521: || p_type || ''' and hl.lookup_code = pgd.' || p_segment;
1522:
3829: begin
3830:
3831: if p_grade_id is not null then
3832:
3833: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
3834: || to_char(p_grade_id)
3835: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3836: || ''' and hl.lookup_code = pgd.' || p_segment;
3837: