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

Line 1821: l_full_name per_all_people_f.full_name%type ;

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

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

Line 2020: l_name per_all_people_f.full_name%type;

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

Line 2026: per_all_people_f ppf,

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

Line 2039: per_all_people_f ppf,

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

Line 4519: l_dpnt_full_name per_all_people_f.full_name%type;

4515: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4516:
4517: l_plan_name ben_pl_f.name%type;
4518: l_option_name ben_opt_f.name%type;
4519: l_dpnt_full_name per_all_people_f.full_name%type;
4520: l_relationship varchar2(200);
4521: --
4522: l_ext_chg_evt_log_id number;
4523: l_object_version_number number;

Line 4544: FROM per_all_people_f ppf

4540: and p_effective_date between opt.effective_start_date and opt.effective_end_date;
4541: --
4542: cursor c_dpnt_full_name (p_person_id number) is
4543: SELECT ppf.full_name
4544: FROM per_all_people_f ppf
4545: WHERE ppf.person_id = p_person_id
4546: AND p_effective_date between ppf.effective_start_date
4547: and ppf.effective_end_date
4548: AND ppf.business_group_id = p_business_group_id;

Line 4812: l_relationship per_all_people_f.person_id%type;

4808: --
4809: -- Local variable declarations
4810: --
4811: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4812: l_relationship per_all_people_f.person_id%type;
4813: l_contact per_contact_relationships.contact_relationship_id%type;
4814: l_name per_all_people_f.full_name%type;
4815: --
4816: cursor c_relationship(p_person_id number) is

Line 4814: l_name per_all_people_f.full_name%type;

4810: --
4811: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4812: l_relationship per_all_people_f.person_id%type;
4813: l_contact per_contact_relationships.contact_relationship_id%type;
4814: l_name per_all_people_f.full_name%type;
4815: --
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,

Line 4819: per_all_people_f ppf,

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

Line 4832: per_all_people_f ppf,

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

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

5662: where hl.lookup_type = 'TERM_APL_REASON'
5663: and hl.lookup_code = p_termination_reason
5664: and hl.enabled_flag = 'Y';
5665: --
5666: cursor c_business_group_id(p_person_id per_all_people_f.person_id%type
5667: /* ,p_effective_dt date */-- commented for bug 3361237
5668: )
5669: is
5670: select ppf.business_group_id

Line 5671: from per_all_people_f ppf

5667: /* ,p_effective_dt date */-- commented for bug 3361237
5668: )
5669: is
5670: select ppf.business_group_id
5671: from per_all_people_f ppf
5672: where ppf.person_id = p_person_id;
5673: /* and p_effective_dt between nvl(ppf.effective_start_date, sysdate)
5674: and nvl(ppf.effective_end_date, sysdate);*/
5675: -- commented for bug 3361237

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

5684: begin
5685: --
5686: hr_utility.set_location('Entering:'||l_proc, 10);
5687: --
5688: if p_event = 'UPDATE' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'
5689: and p_new_rec.phone_type in ('H1', 'W1', 'HF','M') then
5690: --
5691: --Start Bug 1554477
5692: if p_old_rec.date_to is null and

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

5747: l_person_id := p_new_rec.parent_id;
5748: end if;
5749:
5750: --Start Bug 1554477
5751: elsif p_event = 'INSERT' and p_new_rec.parent_table = 'PER_ALL_PEOPLE_F'
5752: and p_new_rec.phone_type in ('H1', 'W1', 'HF', 'M') then
5753: --
5754: if p_old_rec.date_to is null and
5755: p_new_rec.date_to is not null then

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

5804:
5805: l_update_mode := p_new_rec.update_mode;
5806: l_person_id := p_new_rec.parent_id;
5807:
5808: elsif p_event = 'DELETE' and p_old_rec.parent_table = 'PER_ALL_PEOPLE_F'
5809: and p_old_rec.phone_type in ('H1', 'W1', 'HF', 'M') then
5810: --
5811:
5812: if p_old_rec.phone_type = 'H1' then