[Home] [Help]
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;
189: g_pos_report_date date;
190: g_pos_asg_id per_all_assignments_f.assignment_id%type;
191:
192: g_job_name per_jobs.name%type;
1439:
1440: begin
1441: if p_position_id is not null then
1442:
1443: 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 = '
1444: || to_char(p_position_id)
1445: || ' and ppd.position_definition_id = pap.position_definition_id '
1446: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1447: || ' and flv1.lookup_code = ppd.' || p_segment
1585: elsif p_flex = 'Position' then
1586:
1587: begin
1588: if p_position_id is not null then
1589: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
1590: || to_char(p_position_id)
1591: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1592: || p_type || ''' and hl.lookup_code = ppd.' || p_segment;
1593:
3913: begin
3914:
3915: if p_position_id is not null then
3916:
3917: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
3918: || to_char(p_position_id)
3919: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3920: || ''' and hl.lookup_code = ppd.' || p_segment;
3921: