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_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 9108: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------

9104: ---------------------------------------------------------------
9105: -- END OF BEN_CSS_RLTD_PER_PER_IN_LER_F ----------------------
9106: ---------------------------------------------------------------
9107: ---------------------------------------------------------------
9108: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9109: ---------------------------------------------------------------
9110: cursor c_lpl_from_parent(c_LER_ID number) is
9111: select ler_per_info_cs_ler_id
9112: from BEN_LER_PER_INFO_CS_LER_F

Line 9112: from BEN_LER_PER_INFO_CS_LER_F

9108: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9109: ---------------------------------------------------------------
9110: cursor c_lpl_from_parent(c_LER_ID number) is
9111: select ler_per_info_cs_ler_id
9112: from BEN_LER_PER_INFO_CS_LER_F
9113: where LER_ID = c_LER_ID
9114: and ( exists ( select 'x'
9115: from ben_ler_f
9116: where LER_ID = c_LER_ID

Line 9122: from BEN_LER_PER_INFO_CS_LER_F lpl

9118: nvl(p_no_dup_rslt, 'X') = 'Y'); -- For plan design wizard copy lpl also
9119: --
9120: cursor c_lpl(c_ler_per_info_cs_ler_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
9121: select lpl.*
9122: from BEN_LER_PER_INFO_CS_LER_F lpl
9123: where lpl.ler_per_info_cs_ler_id = c_ler_per_info_cs_ler_id
9124: -- and lpl.business_group_id = p_business_group_id
9125: and not exists (
9126: select /*+ */ null

Line 9133: -- and trt.where_clause = 'BEN_LER_PER_INFO_CS_LER_F'

9129: where copy_entity_txn_id = p_copy_entity_txn_id
9130: -- and trt.table_route_id = cpe.table_route_id
9131: and ( -- c_mirror_src_entity_result_id is null or
9132: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9133: -- and trt.where_clause = 'BEN_LER_PER_INFO_CS_LER_F'
9134: and cpe.table_alias = c_table_alias
9135: and information1 = c_ler_per_info_cs_ler_id
9136: -- and information4 = lpl.business_group_id
9137: and information2 = lpl.effective_start_date

Line 9142: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------

9138: and information3 = lpl.effective_end_date
9139: );
9140: l_out_lpl_result_id number(15);
9141: ---------------------------------------------------------------
9142: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9143: ---------------------------------------------------------------
9144: ---------------------------------------------------------------
9145: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9146: ---------------------------------------------------------------

Line 9181: from BEN_LER_PER_INFO_CS_LER_F lpl,

9177: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9178: ---------------------------------------------------------------
9179: cursor c_psl_from_parent(c_LER_PER_INFO_CS_LER_ID number) is
9180: select psl.per_info_chg_cs_ler_id
9181: from BEN_LER_PER_INFO_CS_LER_F lpl,
9182: BEN_PER_INFO_CHG_CS_LER_F psl
9183: where LER_PER_INFO_CS_LER_ID = c_LER_PER_INFO_CS_LER_ID
9184: and psl.PER_INFO_CHG_CS_LER_id = lpl.PER_INFO_CHG_CS_LER_id
9185: and source_table = 'PER_ABSENCE_ATTENDANCES';

Line 9546: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------

9542: ---------------------------------------------------------------
9543: */
9544: -- NOTIMPLEMENTED
9545: ---------------------------------------------------------------
9546: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9547: ---------------------------------------------------------------
9548: --
9549: for l_parent_rec in c_lpl_from_parent(l_LER_ID) loop
9550: --

Line 9814: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------

9810: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9811: ---------------------------------------------------------------
9812: end loop;
9813: ---------------------------------------------------------------
9814: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9815: ---------------------------------------------------------------
9816: /* -- NOTIMPLEMENTED
9817: ---------------------------------------------------------------
9818: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------