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.BEN_EXT_CHLG dependencies on HR_LOOKUPS

Line 204: FROM hr_lookups h

200: ) return boolean is
201: --
202: cursor c_lookup_is_enabled is
203: SELECT null
204: FROM hr_lookups h
205: WHERE h.lookup_type = 'BEN_EXT_CHG_EVT'
206: AND h.lookup_code = p_chg_evt_cd
207: AND h.enabled_flag = 'Y'
208: AND p_effective_date between nvl(start_date_active,p_effective_date)

Line 458: (p_lookup_type hr_lookups.lookup_type%type

454: l_ext_chg_evt_log_id number;
455: l_object_version_number number;
456: --
457: cursor c_lookup_value
458: (p_lookup_type hr_lookups.lookup_type%type
459: ,p_lookup_code hr_lookups.lookup_code%type
460: )
461: is
462: select meaning

Line 459: ,p_lookup_code hr_lookups.lookup_code%type

455: l_object_version_number number;
456: --
457: cursor c_lookup_value
458: (p_lookup_type hr_lookups.lookup_type%type
459: ,p_lookup_code hr_lookups.lookup_code%type
460: )
461: is
462: select meaning
463: from hr_lookups hl

Line 463: from hr_lookups hl

459: ,p_lookup_code hr_lookups.lookup_code%type
460: )
461: is
462: select meaning
463: from hr_lookups hl
464: where hl.lookup_type = p_lookup_type
465: and hl.lookup_code = p_lookup_code;
466:
467: cursor c_benefits_group(p_benfts_grp_id ben_benfts_grp.benfts_grp_id%type)

Line 476: hr_lookups hl

472: --
473: cursor c_relationship(p_person_id number) is
474: SELECT pcr.contact_relationship_id,pcr.person_id
475: FROM per_contact_relationships pcr,
476: hr_lookups hl
477: WHERE pcr.contact_person_id = p_person_id
478: AND pcr.contact_type = hl.lookup_code
479: AND hl.lookup_type = 'CONTACT';
480: --

Line 498: l_old_marital_status hr_lookups.meaning%type ;

494:
495:
496:
497:
498: l_old_marital_status hr_lookups.meaning%type ;
499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;

Line 499: l_new_marital_status hr_lookups.meaning%type ;

495:
496:
497:
498: l_old_marital_status hr_lookups.meaning%type ;
499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;

Line 500: l_old_sex hr_lookups.meaning%type ;

496:
497:
498: l_old_marital_status hr_lookups.meaning%type ;
499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;

Line 501: l_new_sex hr_lookups.meaning%type ;

497:
498: l_old_marital_status hr_lookups.meaning%type ;
499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;

Line 502: l_old_disability_status hr_lookups.meaning%type ;

498: l_old_marital_status hr_lookups.meaning%type ;
499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;

Line 503: l_new_disability_status hr_lookups.meaning%type ;

499: l_new_marital_status hr_lookups.meaning%type ;
500: l_old_sex hr_lookups.meaning%type ;
501: l_new_sex hr_lookups.meaning%type ;
502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;

Line 506: l_old_student_status hr_lookups.meaning%type ;

502: l_old_disability_status hr_lookups.meaning%type ;
503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;
509: l_new_ethnic_group hr_lookups.meaning%type ;
510: l_relationship per_all_people_f.person_id%type;

Line 507: l_new_student_status hr_lookups.meaning%type ;

503: l_new_disability_status hr_lookups.meaning%type ;
504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;
509: l_new_ethnic_group hr_lookups.meaning%type ;
510: l_relationship per_all_people_f.person_id%type;
511: l_contact per_contact_relationships.contact_relationship_id%type;

Line 508: l_old_ethnic_group hr_lookups.meaning%type ;

504: l_old_benefits_group ben_benfts_grp.name%type;
505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;
509: l_new_ethnic_group hr_lookups.meaning%type ;
510: l_relationship per_all_people_f.person_id%type;
511: l_contact per_contact_relationships.contact_relationship_id%type;
512: l_person_type per_person_types.system_person_type%type ;

Line 509: l_new_ethnic_group hr_lookups.meaning%type ;

505: l_new_benefits_group ben_benfts_grp.name%type;
506: l_old_student_status hr_lookups.meaning%type ;
507: l_new_student_status hr_lookups.meaning%type ;
508: l_old_ethnic_group hr_lookups.meaning%type ;
509: l_new_ethnic_group hr_lookups.meaning%type ;
510: l_relationship per_all_people_f.person_id%type;
511: l_contact per_contact_relationships.contact_relationship_id%type;
512: l_person_type per_person_types.system_person_type%type ;
513: --

Line 1855: (p_lookup_code hr_lookups.lookup_code%type

1851: where ppf.person_type_id = ppt.person_type_id
1852: and ppf.person_id = p_person_id;
1853: --
1854: cursor c_lookup_value
1855: (p_lookup_code hr_lookups.lookup_code%type
1856: )
1857: is
1858: select meaning
1859: from hr_lookups hl

Line 1859: from hr_lookups hl

1855: (p_lookup_code hr_lookups.lookup_code%type
1856: )
1857: is
1858: select meaning
1859: from hr_lookups hl
1860: where hl.lookup_type = 'CONTACT'
1861: and hl.lookup_code = p_lookup_code;
1862: begin
1863: --

Line 2028: hr_lookups hl

2024: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
2025: FROM per_contact_relationships pcr,
2026: per_all_people_f ppf,
2027: per_person_types ppt,
2028: hr_lookups hl
2029: WHERE pcr.contact_person_id = p_person_id
2030: AND ppf.person_id = p_person_id
2031: AND ppf.person_type_id = ppt.person_type_id
2032: AND ppt.system_person_type = 'OTHER'

Line 2040: hr_lookups hl

2036: cursor c_con_relationship(p_person_id number,p_effective_date date) is
2037: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
2038: FROM per_contact_relationships pcr,
2039: per_all_people_f ppf,
2040: hr_lookups hl
2041: WHERE pcr.contact_person_id = p_person_id
2042: AND ppf.person_id = p_person_id
2043: AND pcr.contact_type = hl.lookup_code
2044: AND hl.lookup_type = 'CONTACT'

Line 4554: hr_lookups hl

4550: cursor c_relationship(p_person_id number
4551: ,p_dpnt_person_id number)is
4552: SELECT hl.meaning
4553: FROM per_contact_relationships pcr,
4554: hr_lookups hl
4555: WHERE pcr.person_id = p_person_id
4556: AND pcr.contact_person_id = p_dpnt_person_id
4557: AND pcr.contact_type = hl.lookup_code
4558: AND hl.lookup_type = 'CONTACT';

Line 4821: hr_lookups hl

4817: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4818: FROM per_contact_relationships pcr,
4819: per_all_people_f ppf,
4820: per_person_types ppt,
4821: hr_lookups hl
4822: WHERE pcr.contact_person_id = p_person_id
4823: AND ppf.person_id = p_person_id
4824: AND ppf.person_type_id = ppt.person_type_id
4825: AND ppt.system_person_type = 'OTHER'

Line 4833: hr_lookups hl

4829: cursor c_con_relationship(p_person_id number) is
4830: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4831: FROM per_contact_relationships pcr,
4832: per_all_people_f ppf,
4833: hr_lookups hl
4834: WHERE pcr.contact_person_id = p_person_id
4835: AND ppf.person_id = p_person_id
4836: AND pcr.contact_type = hl.lookup_code
4837: AND hl.lookup_type = 'CONTACT'

Line 4862: from hr_lookups hl

4858:
4859: cursor c_prmry_care_prvdr_type(prmry_care_prvdr_typ_cd in varchar2)
4860: is
4861: select hl.meaning
4862: from hr_lookups hl
4863: where hl.lookup_type = 'BEN_PRMRY_CARE_PRVDR_TYP'
4864: and hl.lookup_code = prmry_care_prvdr_typ_cd;
4865: --
4866: l_person_id number;

Line 5385: from hr_lookups hl

5381: --
5382: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5383: is
5384: select hl.meaning
5385: from hr_lookups hl
5386: where hl.lookup_type = 'TERM_APL_REASON'
5387: and hl.lookup_code = p_termination_reason
5388: and hl.enabled_flag = 'Y';
5389: --

Line 5661: from hr_lookups hl

5657: --
5658: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5659: is
5660: select meaning
5661: from hr_lookups hl
5662: where hl.lookup_type = 'TERM_APL_REASON'
5663: and hl.lookup_code = p_termination_reason
5664: and hl.enabled_flag = 'Y';
5665: --

Line 6137: (p_lookup_type hr_lookups.lookup_type%type

6133: l_ext_chg_evt_log_id number;
6134: l_object_version_number number;
6135: --
6136: cursor c_lookup_value
6137: (p_lookup_type hr_lookups.lookup_type%type
6138: ,p_lookup_code hr_lookups.lookup_code%type
6139: )
6140: is
6141: select meaning

Line 6138: ,p_lookup_code hr_lookups.lookup_code%type

6134: l_object_version_number number;
6135: --
6136: cursor c_lookup_value
6137: (p_lookup_type hr_lookups.lookup_type%type
6138: ,p_lookup_code hr_lookups.lookup_code%type
6139: )
6140: is
6141: select meaning
6142: from hr_lookups hl

Line 6142: from hr_lookups hl

6138: ,p_lookup_code hr_lookups.lookup_code%type
6139: )
6140: is
6141: select meaning
6142: from hr_lookups hl
6143: where hl.lookup_type = p_lookup_type
6144: and hl.lookup_code = p_lookup_code;
6145:
6146: --

Line 6151: l_old_categoryname hr_lookups.meaning%type;

6147: l_proc varchar2(100) := 'ben_ext_chlg.log_per_dis_chg';
6148: --
6149:
6150: --
6151: l_old_categoryname hr_lookups.meaning%type;
6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;

Line 6152: l_new_categoryname hr_lookups.meaning%type;

6148: --
6149:
6150: --
6151: l_old_categoryname hr_lookups.meaning%type;
6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;

Line 6153: l_old_reason hr_lookups.meaning%type;

6149:
6150: --
6151: l_old_categoryname hr_lookups.meaning%type;
6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;

Line 6154: l_new_reason hr_lookups.meaning%type;

6150: --
6151: l_old_categoryname hr_lookups.meaning%type;
6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;
6158: l_new_incident per_work_incidents.incident_reference%type;

Line 6155: l_old_status hr_lookups.meaning%type;

6151: l_old_categoryname hr_lookups.meaning%type;
6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;
6158: l_new_incident per_work_incidents.incident_reference%type;
6159: l_old_organization hr_all_organization_units.name%type;

Line 6156: l_new_status hr_lookups.meaning%type;

6152: l_new_categoryname hr_lookups.meaning%type;
6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%type;
6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;
6158: l_new_incident per_work_incidents.incident_reference%type;
6159: l_old_organization hr_all_organization_units.name%type;
6160: l_new_organization hr_all_organization_units.name%type;