APPS.BEN_PER_ASG_EIT_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 67: , ben_ler_rltd_per_cs_ler_f lrp

63: )
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)

Line 101: from ben_ler_rltd_per_cs_ler_f lrp

97: select rpc.source_column
98: , rpc.new_val
99: , rpc.old_val
100: , 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
101: from ben_ler_rltd_per_cs_ler_f lrp
102: , ben_rltd_per_chg_cs_ler_f rpc
103: where lrp.ler_id = p_ler_id
104: and lrp.business_group_id = l_business_group_id
105: and lrp.business_group_id = rpc.business_group_id

Line 446: , ben_ler_rltd_per_cs_ler_f lrp

442: )
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)

Line 480: from ben_ler_rltd_per_cs_ler_f lrp

476: select rpc.source_column
477: , rpc.new_val
478: , rpc.old_val
479: , 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
480: from ben_ler_rltd_per_cs_ler_f lrp
481: , ben_rltd_per_chg_cs_ler_f rpc
482: where lrp.ler_id = p_ler_id
483: and lrp.business_group_id = l_business_group_id
484: and lrp.business_group_id = rpc.business_group_id