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 BEN_RLTD_PER_CHG_CS_LER_F

Line 66: from ben_rltd_per_chg_cs_ler_f rpc

62: and lpl.ler_id = ler.ler_id)
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

Line 102: , ben_rltd_per_chg_cs_ler_f rpc

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
106: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)

Line 149: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;

145: l_effective_start_date DATE;
146: l_ler_id NUMBER;
147: l_typ_cd ben_ler_f.typ_cd%Type ;
148: l_ocrd_dt_cd VARCHAR2(30);
149: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
150: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
151: l_per_info_chg_cs_ler_rl number;
152: l_rule_overrides_flag VARCHAR2(1);
153: l_chg_mandatory_cd VARCHAR2(1);

Line 150: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;

146: l_ler_id NUMBER;
147: l_typ_cd ben_ler_f.typ_cd%Type ;
148: l_ocrd_dt_cd VARCHAR2(30);
149: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
150: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
151: l_per_info_chg_cs_ler_rl number;
152: l_rule_overrides_flag VARCHAR2(1);
153: l_chg_mandatory_cd VARCHAR2(1);
154: l_trigger boolean := TRUE;

Line 158: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;

154: l_trigger boolean := TRUE;
155: l_ovn NUMBER;
156: l_ptnl_id NUMBER;
157: l_type VARCHAR2(1);
158: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
159: l_lf_evt_ocrd_date DATE ;
160: l_le_exists VARCHAR2(1);
161: l_hld_person_id NUMBER;
162: l_rule_output VARCHAR2(1);

Line 445: from ben_rltd_per_chg_cs_ler_f rpc

441: and lpl.ler_id = ler.ler_id)
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

Line 481: , ben_rltd_per_chg_cs_ler_f rpc

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
485: and rpc.source_column = nvl(p_new.information_type,p_old.information_type)

Line 536: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;

532: l_changed BOOLEAN;
533: l_ler_id NUMBER;
534: l_typ_cd ben_ler_f.typ_cd%Type ;
535: l_ocrd_dt_cd VARCHAR2(30);
536: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
537: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
538: l_per_info_chg_cs_ler_rl number;
539: l_rule_overrides_flag VARCHAR2(1);
540: l_chg_mandatory_cd VARCHAR2(1);

Line 537: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;

533: l_ler_id NUMBER;
534: l_typ_cd ben_ler_f.typ_cd%Type ;
535: l_ocrd_dt_cd VARCHAR2(30);
536: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
537: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
538: l_per_info_chg_cs_ler_rl number;
539: l_rule_overrides_flag VARCHAR2(1);
540: l_chg_mandatory_cd VARCHAR2(1);
541: l_trigger boolean := TRUE;

Line 545: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;

541: l_trigger boolean := TRUE;
542: l_ovn NUMBER;
543: l_ptnl_id NUMBER;
544: l_type VARCHAR2(1);
545: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
546: l_lf_evt_ocrd_date DATE ;
547: l_le_exists VARCHAR2(1);
548: l_hld_person_id NUMBER;
549: l_rule_output VARCHAR2(1);