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 PER_PERSON_TYPES

Line 484: from per_person_types ppt

480: AND hl.lookup_type = 'CONTACT';
481: --
482: cursor c_person_type(p_person_type_id number) is
483: select ppt.system_person_type
484: from per_person_types ppt
485: where ppt.person_type_id = p_person_type_id;
486:
487: -- Get all the contact relationship person
488: cursor c_con_relationship(p_person_id number , p_date date ) is

Line 513: l_person_type per_person_types.system_person_type%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: --
515: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
516: --
517: begin

Line 1821: l_person_type per_person_types.system_person_type%type;

1817: l_proc varchar2(100) := 'ben_ext_chlg.log_cont_chg';
1818: l_tab_counter binary_integer := 0;
1819: l_old_contact_type varchar2(100) ;
1820: l_new_contact_type varchar2(100) ;
1821: l_person_type per_person_types.system_person_type%type;
1822: l_full_name per_all_people_f.full_name%type ;
1823: l_chg_evt_tab g_char_tab_type;
1824: l_chg_eff_tab g_date_tab_type;
1825: l_prmtr_01_tab g_char_tab_type;

Line 1851: from per_person_types ppt,per_all_people_f ppf

1847: l_object_version_number number;
1848: --
1849: cursor c_person_type(p_person_id number) is
1850: select ppt.system_person_type,ppf.full_name
1851: from per_person_types ppt,per_all_people_f ppf
1852: where ppf.person_type_id = ppt.person_type_id
1853: and ppf.person_id = p_person_id;
1854: --
1855: cursor c_lookup_value

Line 2028: per_person_types ppt,

2024: cursor c_relationship(p_person_id number) is
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

Line 4916: per_person_types ppt,

4912: cursor c_relationship(p_person_id number) is
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

Line 6014: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)

6010: -- Bug 4705814.
6011: --
6012: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';
6013: --
6014: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
6015: is
6016: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id
6017: from per_person_types ppt
6018: where ppt.person_type_id = p_person_type_id;

Line 6017: from per_person_types ppt

6013: --
6014: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
6015: is
6016: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id
6017: from per_person_types ppt
6018: where ppt.person_type_id = p_person_type_id;
6019: --
6020: l_chg_evt_code varchar2(30);
6021: l_person_type varchar2(30);