[Home] [Help]
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;
193: g_job_report_date date;
194: g_job_asg_id per_all_assignments_f.assignment_id%type;
195:
196: g_lev_name hr_lookups.meaning%type;
1379: begin
1380:
1381: if p_job_id is not null then
1382: -- hr_utility.set_location('Security_grp_Id :' || fnd_global.lookup_security_group('ZA_WSP_OCCUPATIONAL_CATEGORIES',3),30);
1383: 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 = '
1384: || to_char(p_job_id)
1385: || ' and pjd.job_definition_id = pj.job_definition_id '
1386: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''
1387: || ' and flv1.lookup_code = pjd.' || p_segment
1539: if p_flex = 'Job' then
1540:
1541: begin
1542: if p_job_id is not null then
1543: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
1544: || to_char(p_job_id)
1545: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EMP_EQ_OCCUPATIONAL_'
1546: || p_type || ''' and hl.lookup_code = pjd.' || p_segment;
1547:
3863: begin
3864:
3865: if p_job_id is not null then
3866:
3867: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
3868: || to_char(p_job_id)
3869: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = ''ZA_EE_FUNCTION_TYPE'
3870: || ''' and hl.lookup_code = pjd.' || p_segment;
3871: