APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_GRADES

Line 184: g_grade_name per_grades.name%type;

180:
181: g_cat_Enc_Diff_table t_E_differential;
182: g_lev_Enc_Diff_table t_E_differential;
183:
184: g_grade_name per_grades.name%type;
185: g_grade_report_date date;
186: g_grade_asg_id per_all_assignments_f.assignment_id%type;
187:
188: g_position_name per_all_positions.name%type;

Line 1413: 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 = '

1409:
1410: begin
1411: if p_grade_id is not null then
1412:
1413: 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 = '
1414: || to_char(p_grade_id)
1415: || ' and pgd.grade_definition_id = pg.grade_definition_id '
1416: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1417: || ' and flv1.lookup_code = pgd.' || p_segment

Line 1566: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '

1562: elsif p_flex = 'Grade' then
1563:
1564: begin
1565: if p_grade_id is not null then
1566: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
1567: || to_char(p_grade_id)
1568: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1569: || p_type || ''' and hl.lookup_code = pgd.' || p_segment;
1570:

Line 3892: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '

3888: begin
3889:
3890: if p_grade_id is not null then
3891:
3892: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
3893: || to_char(p_grade_id)
3894: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3895: || ''' and hl.lookup_code = pgd.' || p_segment;
3896: