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_PL_F

Line 14564: -- and tr.where_clause = l_BEN_PL_F

14560: from ben_copy_entity_results cpe,
14561: pqh_table_route tr
14562: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14563: and cpe.table_route_id = tr.table_route_id
14564: -- and tr.where_clause = l_BEN_PL_F
14565: and tr.table_alias = l_table_alias
14566: and cpe.number_of_copies = 1 --ADDITION
14567: group by decode(cpe.information160,cpe.information1,1,2), cpe.information1,cpe.information2,cpe.information3,
14568: cpe.information170, cpe.table_route_id ,cpe.dml_operation,cpe.datetrack_mode, cpe.information8

Line 14603: from BEN_PL_F PLN

14599: c_business_group_id number,
14600: c_new_pk_id number) is
14601: select
14602: PLN.pl_id new_value
14603: from BEN_PL_F PLN
14604: where PLN.name = c_PLN_name
14605: and PLN.business_group_id = c_business_group_id
14606: and PLN.pl_id <> c_new_pk_id
14607: --TEMPIK

Line 14613: from BEN_PL_F PLN1

14609: and effective_end_date ;
14610: --END TEMPIK
14611: /*TEMPIK
14612: and exists ( select null
14613: from BEN_PL_F PLN1
14614: where PLN1.name = c_PLN_name
14615: and PLN1.business_group_id = c_business_group_id
14616: and PLN1.effective_start_date <= c_effective_start_date )
14617: and exists ( select null

Line 14618: from BEN_PL_F PLN2

14614: where PLN1.name = c_PLN_name
14615: and PLN1.business_group_id = c_business_group_id
14616: and PLN1.effective_start_date <= c_effective_start_date )
14617: and exists ( select null
14618: from BEN_PL_F PLN2
14619: where PLN2.name = c_PLN_name
14620: and PLN2.business_group_id = c_business_group_id
14621: and PLN2.effective_end_date >= c_effective_end_date )
14622: ;

Line 14631: from ben_pl_f

14627: --
14628: cursor c_get_grp_pl(p_grp_pl_name in varchar2,
14629: p_effective_date in date) is
14630: select name, pl_id
14631: from ben_pl_f
14632: where name = p_grp_pl_name
14633: and p_effective_date between effective_start_date and effective_end_date;
14634:
14635: l_get_grp_pl c_get_grp_pl%rowtype;

Line 14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;

14695: -- Added during PDC change
14696: l_MAPPING_TABLE_PK_ID number;
14697: --
14698: --ML
14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;
14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;

Line 14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;

14696: l_MAPPING_TABLE_PK_ID number;
14697: --
14698: --ML
14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;
14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;
14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;

Line 14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;

14697: --
14698: --ML
14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;
14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;
14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;
14705: --

Line 14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;

14698: --ML
14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;
14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;
14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;
14705: --
14706: begin

Line 14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;

14699: l_SUSP_IF_DPNT_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_DOB_NT_PRV_CD%type;
14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;
14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;
14705: --
14706: begin
14707: -- Initialization

Line 14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;

14700: l_SUSP_IF_DPNT_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_ADR_NT_PRV_CD%type;
14701: l_SUSP_IF_BNF_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_SSN_NT_PRV_CD%type;
14702: l_SUSP_IF_BNF_DOB_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_DOB_NT_PRV_CD%type;
14703: l_SUSP_IF_BNF_ADR_NT_PRV_CD ben_pl_f.SUSP_IF_BNF_ADR_NT_PRV_CD%type;
14704: l_SUSP_IF_DPNT_SSN_NT_PRV_CD ben_pl_f.SUSP_IF_DPNT_SSN_NT_PRV_CD%type;
14705: --
14706: begin
14707: -- Initialization
14708: l_object_found_in_target := false ;

Line 14810: (p_base_table_name => 'BEN_PL_F',

14806: if c_find_PLN_in_target%found then
14807: --
14808: --TEMPIK
14809: l_dt_rec_found := dt_api.check_min_max_dates
14810: (p_base_table_name => 'BEN_PL_F',
14811: p_base_key_column => 'PL_ID',
14812: p_base_key_value => l_new_value,
14813: p_from_date => l_min_esd,
14814: p_to_date => l_max_eed );

Line 14954: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PL_F',l_prefix || r_PLN.INFORMATION170 || l_suffix);

14950: --
14951: end if;
14952: --
14953:
14954: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PL_F',l_prefix || r_PLN.INFORMATION170 || l_suffix);
14955: --
14956:
14957: l_effective_date := r_PLN.information2;
14958: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 15003: hr_utility.set_location(' BEN_PL_F CREATE_PLAN ',20);

14999: l_SUSP_IF_BNF_ADR_NT_PRV_CD := r_PLN.INFORMATION106;
15000: end if;
15001: if l_first_rec and not l_update then
15002: -- Call Create routine.
15003: hr_utility.set_location(' BEN_PL_F CREATE_PLAN ',20);
15004: BEN_PLAN_API.CREATE_PLAN(
15005: --
15006: P_VALIDATE => false
15007: ,P_EFFECTIVE_DATE => l_effective_date

Line 15250: hr_utility.set_location(' BEN_PL_F UPDATE_PLAN ',30);

15246: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15247: --
15248: IF l_update OR l_dml_operation <> 'UPDATE' THEN
15249: --UPD END
15250: hr_utility.set_location(' BEN_PL_F UPDATE_PLAN ',30);
15251: BEN_PLAN_API.UPDATE_PLAN(
15252: --
15253: P_VALIDATE => false
15254: ,P_EFFECTIVE_DATE => l_effective_date