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_ALL_PEOPLE_F

Line 511: l_relationship per_all_people_f.person_id%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: --
515: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';

Line 1822: l_full_name per_all_people_f.full_name%type ;

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;
1826: l_prmtr_02_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 2020: l_relationship per_all_people_f.person_id%type;

2016: l_ext_chg_evt_log_id number;
2017: l_object_version_number number;
2018: l_person_id number;
2019: l_business_group_id number;
2020: l_relationship per_all_people_f.person_id%type;
2021: l_name per_all_people_f.full_name%type;
2022: l_contact per_contact_relationships.contact_relationship_id%type;
2023: --
2024: cursor c_relationship(p_person_id number) is

Line 2021: l_name per_all_people_f.full_name%type;

2017: l_object_version_number number;
2018: l_person_id number;
2019: l_business_group_id number;
2020: l_relationship per_all_people_f.person_id%type;
2021: l_name per_all_people_f.full_name%type;
2022: l_contact per_contact_relationships.contact_relationship_id%type;
2023: --
2024: cursor c_relationship(p_person_id number) is
2025: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name

Line 2027: per_all_people_f ppf,

2023: --
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

Line 2040: per_all_people_f ppf,

2036:
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

Line 4615: l_dpnt_full_name per_all_people_f.full_name%type;

4611: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4612:
4613: l_plan_name ben_pl_f.name%type;
4614: l_option_name ben_opt_f.name%type;
4615: l_dpnt_full_name per_all_people_f.full_name%type;
4616: l_relationship varchar2(200);
4617: --
4618: l_ext_chg_evt_log_id number;
4619: l_object_version_number number;

Line 4640: FROM per_all_people_f ppf

4636: and p_effective_date between opt.effective_start_date and opt.effective_end_date;
4637: --
4638: cursor c_dpnt_full_name (p_person_id number) is
4639: SELECT ppf.full_name
4640: FROM per_all_people_f ppf
4641: WHERE ppf.person_id = p_person_id
4642: AND p_effective_date between ppf.effective_start_date
4643: and ppf.effective_end_date
4644: AND ppf.business_group_id = p_business_group_id;

Line 4908: l_relationship per_all_people_f.person_id%type;

4904: --
4905: -- Local variable declarations
4906: --
4907: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4908: l_relationship per_all_people_f.person_id%type;
4909: l_contact per_contact_relationships.contact_relationship_id%type;
4910: l_name per_all_people_f.full_name%type;
4911: --
4912: cursor c_relationship(p_person_id number) is

Line 4910: l_name per_all_people_f.full_name%type;

4906: --
4907: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4908: l_relationship per_all_people_f.person_id%type;
4909: l_contact per_contact_relationships.contact_relationship_id%type;
4910: l_name per_all_people_f.full_name%type;
4911: --
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,

Line 4915: per_all_people_f ppf,

4911: --
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

Line 4928: per_all_people_f ppf,

4924:
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

Line 5762: cursor c_business_group_id(p_person_id per_all_people_f.person_id%type

5758: where hl.lookup_type = 'TERM_APL_REASON'
5759: and hl.lookup_code = p_termination_reason
5760: and hl.enabled_flag = 'Y';
5761: --
5762: cursor c_business_group_id(p_person_id per_all_people_f.person_id%type
5763: /* ,p_effective_dt date */-- commented for bug 3361237
5764: )
5765: is
5766: select ppf.business_group_id

Line 5767: from per_all_people_f ppf

5763: /* ,p_effective_dt date */-- commented for bug 3361237
5764: )
5765: is
5766: select ppf.business_group_id
5767: from per_all_people_f ppf
5768: where ppf.person_id = p_person_id;
5769: /* and p_effective_dt between nvl(ppf.effective_start_date, sysdate)
5770: and nvl(ppf.effective_end_date, sysdate);*/
5771: -- commented for bug 3361237

Line 5784: if p_event = 'UPDATE' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'

5780: begin
5781: --
5782: hr_utility.set_location('Entering:'||l_proc, 10);
5783: --
5784: if p_event = 'UPDATE' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'
5785: and p_new_rec.phone_type in ('H1', 'W1', 'HF','M') then
5786: --
5787: --Start Bug 1554477
5788: if p_old_rec.date_to is null and

Line 5847: elsif p_event = 'INSERT' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'

5843: l_person_id := p_new_rec.parent_id;
5844: end if;
5845:
5846: --Start Bug 1554477
5847: elsif p_event = 'INSERT' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'
5848: and p_new_rec.phone_type in ('H1', 'W1', 'HF', 'M') then
5849: --
5850: if p_old_rec.date_to is null and
5851: p_new_rec.date_to is not null then

Line 5904: elsif p_event = 'DELETE' and p_old_rec.parent_table = 'PER_ALL_PEOPLE_F'

5900:
5901: l_update_mode := p_new_rec.update_mode;
5902: l_person_id := p_new_rec.parent_id;
5903:
5904: elsif p_event = 'DELETE' and p_old_rec.parent_table = 'PER_ALL_PEOPLE_F'
5905: and p_old_rec.phone_type in ('H1', 'W1', 'HF', 'M') then
5906: --
5907:
5908: if p_old_rec.phone_type = 'H1' then