[Home] [Help]
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;
146: g_job_report_date date;
147: g_job_asg_id per_all_assignments_f.assignment_id%type;
148:
149: g_lev_name hr_lookups.meaning%type;
1331: begin
1332:
1333: if p_job_id is not null then
1334: -- hr_utility.set_location('Security_grp_Id :' || fnd_global.lookup_security_group('ZA_WSP_OCCUPATIONAL_CATEGORIES',3),30);
1335: l_sql := 'select decode(flv1.attribute1,null,flv1.meaning, flv2.meaning) from fnd_lookup_values flv1, fnd_lookup_values flv2, per_job_definitions pjd, per_jobs pj where pj.job_id = '
1336: || to_char(p_job_id)
1337: || ' and pjd.job_definition_id = pj.job_definition_id '
1338: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1339: || ' and flv1.lookup_code = pjd.' || p_segment
1491: if p_flex = 'Job' then
1492:
1493: begin
1494: if p_job_id is not null then
1495: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
1496: || to_char(p_job_id)
1497: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1498: || p_type || ''' and hl.lookup_code = pjd.' || p_segment;
1499:
3804: begin
3805:
3806: if p_job_id is not null then
3807:
3808: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
3809: || to_char(p_job_id)
3810: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3811: || ''' and hl.lookup_code = pjd.' || p_segment;
3812: