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.

APPS.BEN_EXT_CHLG dependencies on HR_LOOKUPS

Line 205: FROM hr_lookups h

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

Line 459: (p_lookup_type hr_lookups.lookup_type%type

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

Line 460: ,p_lookup_code hr_lookups.lookup_code%type

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

Line 464: from hr_lookups hl

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

Line 477: hr_lookups hl

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

Line 499: l_old_marital_status hr_lookups.meaning%type ;

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

Line 500: l_new_marital_status hr_lookups.meaning%type ;

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

Line 501: l_old_sex hr_lookups.meaning%type ;

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

Line 502: l_new_sex hr_lookups.meaning%type ;

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

Line 503: l_old_disability_status hr_lookups.meaning%type ;

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

Line 504: l_new_disability_status hr_lookups.meaning%type ;

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

Line 507: l_old_student_status hr_lookups.meaning%type ;

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

Line 508: l_new_student_status hr_lookups.meaning%type ;

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

Line 509: l_old_ethnic_group hr_lookups.meaning%type ;

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

Line 510: l_new_ethnic_group hr_lookups.meaning%type ;

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

Line 1856: (p_lookup_code hr_lookups.lookup_code%type

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

Line 1860: from hr_lookups hl

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

Line 2029: hr_lookups hl

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

Line 2041: hr_lookups hl

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

Line 4650: hr_lookups hl

4646: cursor c_relationship(p_person_id number
4647: ,p_dpnt_person_id number)is
4648: SELECT hl.meaning
4649: FROM per_contact_relationships pcr,
4650: hr_lookups hl
4651: WHERE pcr.person_id = p_person_id
4652: AND pcr.contact_person_id = p_dpnt_person_id
4653: AND pcr.contact_type = hl.lookup_code
4654: AND hl.lookup_type = 'CONTACT';

Line 4917: hr_lookups hl

4913: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4914: FROM per_contact_relationships pcr,
4915: per_all_people_f ppf,
4916: per_person_types ppt,
4917: hr_lookups hl
4918: WHERE pcr.contact_person_id = p_person_id
4919: AND ppf.person_id = p_person_id
4920: AND ppf.person_type_id = ppt.person_type_id
4921: AND ppt.system_person_type = 'OTHER'

Line 4929: hr_lookups hl

4925: cursor c_con_relationship(p_person_id number) is
4926: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4927: FROM per_contact_relationships pcr,
4928: per_all_people_f ppf,
4929: hr_lookups hl
4930: WHERE pcr.contact_person_id = p_person_id
4931: AND ppf.person_id = p_person_id
4932: AND pcr.contact_type = hl.lookup_code
4933: AND hl.lookup_type = 'CONTACT'

Line 4958: from hr_lookups hl

4954:
4955: cursor c_prmry_care_prvdr_type(prmry_care_prvdr_typ_cd in varchar2)
4956: is
4957: select hl.meaning
4958: from hr_lookups hl
4959: where hl.lookup_type = 'BEN_PRMRY_CARE_PRVDR_TYP'
4960: and hl.lookup_code = prmry_care_prvdr_typ_cd;
4961: --
4962: l_person_id number;

Line 5481: from hr_lookups hl

5477: --
5478: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5479: is
5480: select hl.meaning
5481: from hr_lookups hl
5482: where hl.lookup_type = 'TERM_APL_REASON'
5483: and hl.lookup_code = p_termination_reason
5484: and hl.enabled_flag = 'Y';
5485: --

Line 5757: from hr_lookups hl

5753: --
5754: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5755: is
5756: select meaning
5757: from hr_lookups hl
5758: where hl.lookup_type = 'TERM_APL_REASON'
5759: and hl.lookup_code = p_termination_reason
5760: and hl.enabled_flag = 'Y';
5761: --

Line 6233: (p_lookup_type hr_lookups.lookup_type%type

6229: l_ext_chg_evt_log_id number;
6230: l_object_version_number number;
6231: --
6232: cursor c_lookup_value
6233: (p_lookup_type hr_lookups.lookup_type%type
6234: ,p_lookup_code hr_lookups.lookup_code%type
6235: )
6236: is
6237: select meaning

Line 6234: ,p_lookup_code hr_lookups.lookup_code%type

6230: l_object_version_number number;
6231: --
6232: cursor c_lookup_value
6233: (p_lookup_type hr_lookups.lookup_type%type
6234: ,p_lookup_code hr_lookups.lookup_code%type
6235: )
6236: is
6237: select meaning
6238: from hr_lookups hl

Line 6238: from hr_lookups hl

6234: ,p_lookup_code hr_lookups.lookup_code%type
6235: )
6236: is
6237: select meaning
6238: from hr_lookups hl
6239: where hl.lookup_type = p_lookup_type
6240: and hl.lookup_code = p_lookup_code;
6241:
6242: --

Line 6247: l_old_categoryname hr_lookups.meaning%type;

6243: l_proc varchar2(100) := 'ben_ext_chlg.log_per_dis_chg';
6244: --
6245:
6246: --
6247: l_old_categoryname hr_lookups.meaning%type;
6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;

Line 6248: l_new_categoryname hr_lookups.meaning%type;

6244: --
6245:
6246: --
6247: l_old_categoryname hr_lookups.meaning%type;
6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;

Line 6249: l_old_reason hr_lookups.meaning%type;

6245:
6246: --
6247: l_old_categoryname hr_lookups.meaning%type;
6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;

Line 6250: l_new_reason hr_lookups.meaning%type;

6246: --
6247: l_old_categoryname hr_lookups.meaning%type;
6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;
6254: l_new_incident per_work_incidents.incident_reference%type;

Line 6251: l_old_status hr_lookups.meaning%type;

6247: l_old_categoryname hr_lookups.meaning%type;
6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;
6254: l_new_incident per_work_incidents.incident_reference%type;
6255: l_old_organization hr_all_organization_units.name%type;

Line 6252: l_new_status hr_lookups.meaning%type;

6248: l_new_categoryname hr_lookups.meaning%type;
6249: l_old_reason hr_lookups.meaning%type;
6250: l_new_reason hr_lookups.meaning%type;
6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;
6254: l_new_incident per_work_incidents.incident_reference%type;
6255: l_old_organization hr_all_organization_units.name%type;
6256: l_new_organization hr_all_organization_units.name%type;