[Home] [Help]
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;
142: g_pos_report_date date;
143: g_pos_asg_id per_all_assignments_f.assignment_id%type;
144:
145: g_job_name per_jobs.name%type;
1391:
1392: begin
1393: if p_position_id is not null then
1394:
1395: l_sql := 'select decode(flv1.attribute1,null,flv1.meaning, flv2.meaning) from fnd_lookup_values flv1, fnd_lookup_values flv2, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
1396: || to_char(p_position_id)
1397: || ' and ppd.position_definition_id = pap.position_definition_id '
1398: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1399: || ' and flv1.lookup_code = ppd.' || p_segment
1537: elsif p_flex = 'Position' then
1538:
1539: begin
1540: if p_position_id is not null then
1541: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
1542: || to_char(p_position_id)
1543: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1544: || p_type || ''' and hl.lookup_code = ppd.' || p_segment;
1545:
3854: begin
3855:
3856: if p_position_id is not null then
3857:
3858: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
3859: || to_char(p_position_id)
3860: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3861: || ''' and hl.lookup_code = ppd.' || p_segment;
3862: