eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on HR_LOOKUPS

Line 2859: , p_ass_cat_name in hr_lookups.meaning%type

2855: , p_person_id in per_all_assignments_f.person_id%type
2856: , p_assignment_id in per_all_assignments_f.assignment_id%type
2857: , p_race in per_all_people_f.per_information4%type
2858: , p_sex in per_all_people_f.sex%type
2859: , p_ass_cat_name in hr_lookups.meaning%type
2860: , p_skills_pri_id in number
2861: , p_trng_event_id in number
2862: , p_trng_event_name in varchar2
2863: , p_trng_event_lookup in varchar2

Line 2937: , p_ass_cat_name in hr_lookups.meaning%type

2933: , p_person_id in per_all_assignments_f.person_id%type
2934: , p_assignment_id in per_all_assignments_f.assignment_id%type
2935: , p_race in per_all_people_f.per_information4%type
2936: , p_sex in per_all_people_f.sex%type
2937: , p_ass_cat_name in hr_lookups.meaning%type
2938: , p_legal_entity_id in number
2939: , p_disability in varchar2
2940: ) is
2941: --

Line 3474: , p_ass_cat_name in hr_lookups.meaning%type

3470: , p_person_id in per_all_assignments_f.person_id%type
3471: , p_assignment_id in per_all_assignments_f.assignment_id%type
3472: , p_race in per_all_people_f.per_information4%type
3473: , p_sex in per_all_people_f.sex%type
3474: , p_ass_cat_name in hr_lookups.meaning%type
3475: , p_skills_pri_id in number
3476: , p_trng_event_id in number
3477: , p_trng_event_name in varchar2
3478: , p_trng_event_lookup in varchar2

Line 3558: , p_ass_cat_name in hr_lookups.meaning%type

3554: , p_person_id in per_all_assignments_f.person_id%type
3555: , p_assignment_id in per_all_assignments_f.assignment_id%type
3556: , p_race in per_all_people_f.per_information4%type
3557: , p_sex in per_all_people_f.sex%type
3558: , p_ass_cat_name in hr_lookups.meaning%type
3559: , p_legal_entity_id in number
3560: , p_disability in varchar2
3561: ) is
3562: l_proc varchar2(50);

Line 4037: l_name hr_lookups.meaning%type;

4033: p_position_id in per_all_assignments_f.position_id%type
4034: ) return varchar2 is
4035:
4036: l_sql varchar2(32767);
4037: l_name hr_lookups.meaning%type;
4038:
4039:
4040: begin
4041: hr_utility.set_location('In side get_occupational_data',1);

Line 4046: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '

4042: hr_utility.set_location('p_flex : ' || p_flex,2);
4043: if p_flex = upper('Job') then
4044: begin
4045: if p_job_id is not null then
4046: l_sql := 'select hl.meaning from hr_lookups hl, per_job_definitions pjd, per_jobs pj where pj.job_id = '
4047: || to_char(p_job_id)
4048: || ' and pjd.job_definition_id = pj.job_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4049: || p_type || ''' and hl.lookup_code = pjd.' || p_segment;
4050: execute immediate l_sql into l_name;

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

4057: end;
4058: elsif p_flex = upper('Grade') then
4059: begin
4060: if p_grade_id is not null then
4061: l_sql := 'select hl.meaning from hr_lookups hl, per_grade_definitions pgd, per_grades pg where pg.grade_id = '
4062: || to_char(p_grade_id)
4063: || ' and pgd.grade_definition_id = pg.grade_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4064: || p_type ||''' and hl.lookup_code = pgd.' || p_segment;
4065: execute immediate l_sql into l_name;

Line 4076: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '

4072: end;
4073: elsif p_flex = upper('Position') then
4074: begin
4075: if p_position_id is not null then
4076: l_sql := 'select hl.meaning from hr_lookups hl, per_position_definitions ppd, per_all_positions pap where pap.position_id = '
4077: || to_char(p_position_id)
4078: || ' and ppd.position_definition_id = pap.position_definition_id and hl.application_id = 800 and hl.lookup_type = '''
4079: || p_type || ''' and hl.lookup_code = ppd.' || p_segment;
4080: execute immediate l_sql into l_name;

Line 4106: l_cat_name hr_lookups.meaning%type;

4102: p_grade_id in per_all_assignments_f.grade_id%type,
4103: p_position_id in per_all_assignments_f.position_id%type,
4104: p_business_group_id in per_all_assignments_f.business_group_id%type
4105: ) return varchar2 is
4106: l_cat_name hr_lookups.meaning%type;
4107: begin
4108: -- Check whether we have cached the location of Occupational data
4109: hr_utility.set_location('Entering get_occupational_category', 10);
4110: hr_utility.set_location('p_assignment_id : '||p_assignment_id, 10);

Line 4144: l_ass_cat_name hr_lookups.meaning%type;

4140:
4141: l_proc varchar2(50);
4142: l_assignment_id per_all_assignments_f.assignment_id%type;
4143: l_person_id per_all_assignments_f.person_id%type;
4144: l_ass_cat_name hr_lookups.meaning%type;
4145: l_race per_all_people_f.per_information4%type;
4146: l_sex per_all_people_f.sex%type;
4147: l_legal_entity_id number(30);
4148: l_disability varchar2(30);