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_ASSIGNMENT_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 434: where source_table = 'PER_ASSIGNMENT_EXTRA_INFO'

430: and ( (exists
431: (select 1
432: from ben_per_info_chg_cs_ler_f psl
433: , ben_ler_per_info_cs_ler_f lpl
434: where source_table = 'PER_ASSIGNMENT_EXTRA_INFO'
435: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
436: and lpl.business_group_id = psl.business_group_id
437: and lpl.business_group_id = ler.business_group_id
438: and psl.source_column =nvl(p_new.information_type,p_old.information_type)

Line 447: where source_table = 'PER_ASSIGNMENT_EXTRA_INFO'

443: OR (exists
444: (select 1
445: from ben_rltd_per_chg_cs_ler_f rpc
446: , ben_ler_rltd_per_cs_ler_f lrp
447: where source_table = 'PER_ASSIGNMENT_EXTRA_INFO'
448: and lrp.business_group_id = rpc.business_group_id
449: and lrp.business_group_id = ler.business_group_id
450: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)
451: and l_session_date between rpc.effective_start_date and rpc.effective_end_date

Line 472: and source_table = 'PER_ASSIGNMENT_EXTRA_INFO'

468: and lpl.business_group_id = psl.business_group_id
469: and psl.source_column =nvl(p_new.information_type,p_old.information_type)
470: and l_session_date between psl.effective_start_date and psl.effective_end_date
471: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
472: and source_table = 'PER_ASSIGNMENT_EXTRA_INFO'
473: and l_session_date between psl.effective_start_date and psl.effective_end_date
474: and l_session_date between lpl.effective_start_date and lpl.effective_end_date
475: UNION
476: select rpc.source_column

Line 488: and source_table = 'PER_ASSIGNMENT_EXTRA_INFO'

484: and lrp.business_group_id = rpc.business_group_id
485: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)
486: and l_session_date between rpc.effective_start_date and rpc.effective_end_date
487: and rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
488: and source_table = 'PER_ASSIGNMENT_EXTRA_INFO'
489: and l_session_date between rpc.effective_start_date and rpc.effective_end_date
490: and l_session_date between lrp.effective_start_date and lrp.effective_end_date
491: order by 1;
492: --

Line 965: FROM per_assignment_extra_info

961: is
962: SELECT assignment_extra_info_id
963: ,assignment_id
964: ,information_type
965: FROM per_assignment_extra_info
966: WHERE assignment_extra_info_id = p_assignment_extra_info_id;
967:
968: c_new_rec ben_per_asg_eit_ler.g_asg_ler_rec;
969: c_old_rec ben_per_asg_eit_ler.g_asg_ler_rec;