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_PD_COPY_TO_BEN_ONE dependencies on BEN_LER_F

Line 9551: -- and tr.where_clause = l_BEN_LER_F

9547: from ben_copy_entity_results cpe,
9548: pqh_table_route tr
9549: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9550: and cpe.table_route_id = tr.table_route_id
9551: -- and tr.where_clause = l_BEN_LER_F
9552: and tr.table_alias = l_table_alias
9553: and cpe.number_of_copies = 1 --ADDITION
9554: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170,
9555: cpe.information16, cpe.information13,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 9590: from BEN_LER_F LER

9586: c_business_group_id number,
9587: c_new_pk_id number) is
9588: select
9589: LER.ler_id new_value
9590: from BEN_LER_F LER
9591: where LER.name = c_LER_name
9592: and LER.business_group_id = c_business_group_id
9593: and LER.ler_id <> c_new_pk_id
9594: --TEMPIK

Line 9600: from BEN_LER_F LER1

9596: and effective_end_date ;
9597: --END TEMPIK
9598: /*TEMPIK
9599: and exists ( select null
9600: from BEN_LER_F LER1
9601: where LER1.name = c_LER_name
9602: and LER1.business_group_id = c_business_group_id
9603: and LER1.effective_start_date <= c_effective_start_date )
9604: and exists ( select null

Line 9605: from BEN_LER_F LER2

9601: where LER1.name = c_LER_name
9602: and LER1.business_group_id = c_business_group_id
9603: and LER1.effective_start_date <= c_effective_start_date )
9604: and exists ( select null
9605: from BEN_LER_F LER2
9606: where LER2.name = c_LER_name
9607: and LER2.business_group_id = c_business_group_id
9608: and LER2.effective_end_date >= c_effective_end_date )
9609: ;

Line 9623: from BEN_LER_F LER

9619: c_business_group_id number,
9620: c_new_pk_id number) is
9621: select
9622: LER.ler_id new_value
9623: from BEN_LER_F LER
9624: where LER.typ_cd = c_LER_TYP_cd
9625: -- 3508427: Including LE's of type Derived and Scheduled along with Abscences.
9626: -- and LER.lf_evt_oper_cd = c_LF_EVT_OPER_cd
9627: and ((LER.typ_cd = 'ABS' and LER.lf_evt_oper_cd = c_LF_EVT_OPER_cd )

Line 9641: from BEN_LER_F LER1

9637: and effective_end_date ;
9638: --END TEMPIK
9639: /*TEMPIK
9640: and exists ( select null
9641: from BEN_LER_F LER1
9642: where LER1.typ_cd = c_LER_TYP_cd
9643: and LER1.lf_evt_oper_cd = c_LF_EVT_OPER_cd
9644: and LER1.ler_id = LER.ler_id
9645: and LER1.business_group_id = c_business_group_id

Line 9648: from BEN_LER_F LER2

9644: and LER1.ler_id = LER.ler_id
9645: and LER1.business_group_id = c_business_group_id
9646: and LER1.effective_start_date <= c_effective_start_date )
9647: and exists ( select null
9648: from BEN_LER_F LER2
9649: where LER2.typ_cd = c_LER_TYP_cd
9650: and LER2.lf_evt_oper_cd = c_LF_EVT_OPER_cd
9651: and LER2.ler_id = LER.ler_id
9652: and LER2.business_group_id = c_business_group_id

Line 9665: from BEN_LER_F LER

9661: c_business_group_id number,
9662: c_new_pk_id number) is
9663: select
9664: LER.name
9665: from BEN_LER_F LER
9666: where LER.typ_cd = c_LER_TYP_cd
9667: and LER.lf_evt_oper_cd = c_LF_EVT_OPER_cd
9668: and LER.business_group_id = c_business_group_id
9669: and LER.ler_id <> c_new_pk_id

Line 9701: l_target_ler_name ben_ler_f.name%type;

9697: l_min_esd date;
9698: l_max_eed date;
9699: l_LER_EVAL_RL number;
9700: l_TMLNS_PERD_RL number;
9701: l_target_ler_name ben_ler_f.name%type;
9702: l_source_ler_name ben_ler_f.name%type;
9703: l_effective_date date;
9704: --
9705: begin

Line 9702: l_source_ler_name ben_ler_f.name%type;

9698: l_max_eed date;
9699: l_LER_EVAL_RL number;
9700: l_TMLNS_PERD_RL number;
9701: l_target_ler_name ben_ler_f.name%type;
9702: l_source_ler_name ben_ler_f.name%type;
9703: l_effective_date date;
9704: --
9705: begin
9706: -- Initialization

Line 9804: (p_base_table_name => 'BEN_LER_F',

9800: --TEMPIK
9801: hr_utility.set_location('New value '||l_new_value,102);
9802: if l_new_value is not null then
9803: l_dt_rec_found := dt_api.check_min_max_dates
9804: (p_base_table_name => 'BEN_LER_F',
9805: p_base_key_column => 'LER_ID',
9806: p_base_key_value => l_new_value,
9807: p_from_date => l_min_esd,
9808: p_to_date => l_max_eed );

Line 9823: (p_base_table_name => 'BEN_LER_F',

9819: fetch c_find_LER_in_target into l_new_value ;
9820: --TEMPIK
9821: if l_new_value is not null then
9822: l_dt_rec_found := dt_api.check_min_max_dates
9823: (p_base_table_name => 'BEN_LER_F',
9824: p_base_key_column => 'LER_ID',
9825: p_base_key_value => l_new_value,
9826: p_from_date => l_min_esd,
9827: p_to_date => l_max_eed );

Line 9849: (p_base_table_name => 'BEN_LER_F',

9845: fetch c_find_LER_TYP_in_target into l_new_value ;
9846: --TEMPIK
9847: if l_new_value is not null then
9848: l_dt_rec_found := dt_api.check_min_max_dates
9849: (p_base_table_name => 'BEN_LER_F',
9850: p_base_key_column => 'LER_ID',
9851: p_base_key_value => l_new_value,
9852: p_from_date => l_min_esd,
9853: p_to_date => l_max_eed );

Line 9942: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_LER_F',l_prefix || r_LER.information170 || l_suffix);

9938:
9939: l_LER_EVAL_RL := get_fk('FORMULA_ID', r_LER.INFORMATION261,l_dml_operation );
9940: l_TMLNS_PERD_RL := get_fk('FORMULA_ID', r_LER.INFORMATION262,l_dml_operation );
9941: --
9942: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_LER_F',l_prefix || r_LER.information170 || l_suffix);
9943: --
9944:
9945: l_effective_date := r_LER.information2;
9946: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 9953: hr_utility.set_location(' BEN_LER_F CREATE_LIFE_EVENT_REASON ',20);

9949: end if;
9950:
9951: if l_first_rec and not l_update then
9952: -- Call Create routine.
9953: hr_utility.set_location(' BEN_LER_F CREATE_LIFE_EVENT_REASON ',20);
9954: BEN_LIFE_EVENT_REASON_API.CREATE_LIFE_EVENT_REASON(
9955: --
9956: P_VALIDATE => false
9957: ,P_EFFECTIVE_DATE => l_effective_date

Line 10063: hr_utility.set_location(' BEN_LER_F UPDATE_LIFE_EVENT_REASON ',30);

10059: --
10060: IF l_update OR l_dml_operation <> 'UPDATE' THEN
10061: -- Call Update routine for the pk_id created in prev run .
10062: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
10063: hr_utility.set_location(' BEN_LER_F UPDATE_LIFE_EVENT_REASON ',30);
10064: BEN_LIFE_EVENT_REASON_API.UPDATE_LIFE_EVENT_REASON(
10065: --
10066: P_VALIDATE => false
10067: ,P_EFFECTIVE_DATE => l_effective_date