APPS.BEN_EXT_CHLG dependencies on PER_PERSON_TYPES

Line 483: from per_person_types ppt

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

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

Line 1820: l_person_type per_person_types.system_person_type%type;

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

Line 1850: from per_person_types ppt,per_all_people_f ppf

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

Line 2027: per_person_types ppt,

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

Line 4820: per_person_types ppt,

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

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

5914: -- Bug 4705814.
5915: --
5916: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';
5917: --
5918: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
5919: is
5920: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id
5921: from per_person_types ppt
5922: where ppt.person_type_id = p_person_type_id;

Line 5921: from per_person_types ppt

5917: --
5918: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
5919: is
5920: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id
5921: from per_person_types ppt
5922: where ppt.person_type_id = p_person_type_id;
5923: --
5924: l_chg_evt_code varchar2(30);
5925: l_person_type varchar2(30);