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_PER_ASG_EIT_LER dependencies on PER_PEOPLE_EXTRA_INFO

Line 14: per_people_extra_info , per_assignment_extra_info

10: */
11: /*
12: Purpose
13: This package is used to Create Life events based on the tables
14: per_people_extra_info , per_assignment_extra_info
15: History
16: Date Who Version What?
17: ---- --- ------- -----
18: 10-Jan-2013 usaraswa 120.0 Initial Version

Line 55: where source_table = 'PER_PEOPLE_EXTRA_INFO'

51: and ( (exists
52: (select 1
53: from ben_per_info_chg_cs_ler_f psl
54: , ben_ler_per_info_cs_ler_f lpl
55: where source_table = 'PER_PEOPLE_EXTRA_INFO'
56: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
57: and lpl.business_group_id = psl.business_group_id
58: and lpl.business_group_id = ler.business_group_id
59: and psl.source_column = nvl(p_new.information_type,p_old.information_type)

Line 68: where source_table = 'PER_PEOPLE_EXTRA_INFO'

64: OR (exists
65: (select 1
66: from ben_rltd_per_chg_cs_ler_f rpc
67: , ben_ler_rltd_per_cs_ler_f lrp
68: where source_table = 'PER_PEOPLE_EXTRA_INFO'
69: and lrp.business_group_id = rpc.business_group_id
70: and lrp.business_group_id = ler.business_group_id
71: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)
72: and l_session_date between rpc.effective_start_date and rpc.effective_end_date

Line 93: and source_table = 'PER_PEOPLE_EXTRA_INFO'

89: and lpl.business_group_id = psl.business_group_id
90: and psl.source_column = nvl(p_new.information_type,p_old.information_type)
91: and l_session_date between psl.effective_start_date and psl.effective_end_date
92: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
93: and source_table = 'PER_PEOPLE_EXTRA_INFO'
94: and l_session_date between psl.effective_start_date and psl.effective_end_date
95: and l_session_date between lpl.effective_start_date and lpl.effective_end_date
96: UNION
97: select rpc.source_column

Line 109: and source_table = 'PER_PEOPLE_EXTRA_INFO'

105: and lrp.business_group_id = rpc.business_group_id
106: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)
107: and l_session_date between rpc.effective_start_date and rpc.effective_end_date
108: and rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
109: and source_table = 'PER_PEOPLE_EXTRA_INFO'
110: and l_session_date between rpc.effective_start_date and rpc.effective_end_date
111: and l_session_date between lrp.effective_start_date and lrp.effective_end_date
112: order by 1;
113: --

Line 790: ,p_INFORMATION_TYPE in per_people_extra_info.information_type%TYPE)

786:
787: ----------------------------------------------------------------------------------------------
788: procedure create_ler_per (p_person_extra_info_id In number
789: ,p_person_id in number
790: ,p_INFORMATION_TYPE in per_people_extra_info.information_type%TYPE)
791: is
792:
793: l_proc varchar2(200) := 'ben_per_asg_eit_ler.create_ler_per';
794: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;

Line 835: FROM per_people_extra_info

831: is
832: SELECT person_extra_info_id
833: ,person_id
834: ,information_type
835: FROM per_people_extra_info
836: WHERE person_extra_info_id = p_person_extra_info_id;
837:
838: c_old_rec ben_per_asg_eit_ler.g_per_ler_rec;
839: c_new_rec ben_per_asg_eit_ler.g_per_ler_rec;