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.

[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_ENRT_CTFN_F

Line 982: -- START OF BEN_LER_ENRT_CTFN_F ----------------------

978: ---------------------------------------------------------------
979: -- END OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
980: ---------------------------------------------------------------
981: ---------------------------------------------------------------
982: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
983: ---------------------------------------------------------------
984: cursor c_lnc_from_parent(c_LER_RQRS_ENRT_CTFN_ID number) is
985: select ler_enrt_ctfn_id
986: from BEN_LER_ENRT_CTFN_F

Line 986: from BEN_LER_ENRT_CTFN_F

982: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
983: ---------------------------------------------------------------
984: cursor c_lnc_from_parent(c_LER_RQRS_ENRT_CTFN_ID number) is
985: select ler_enrt_ctfn_id
986: from BEN_LER_ENRT_CTFN_F
987: where LER_RQRS_ENRT_CTFN_ID = c_LER_RQRS_ENRT_CTFN_ID ;
988: --
989: cursor c_lnc(c_ler_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
990: c_table_alias varchar2) is

Line 992: from BEN_LER_ENRT_CTFN_F lnc

988: --
989: cursor c_lnc(c_ler_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
990: c_table_alias varchar2) is
991: select lnc.*
992: from BEN_LER_ENRT_CTFN_F lnc
993: where lnc.ler_enrt_ctfn_id = c_ler_enrt_ctfn_id
994: -- and lnc.business_group_id = p_business_group_id
995: and not exists (
996: select /*+ */ null

Line 1003: -- and trt.where_clause = 'BEN_LER_ENRT_CTFN_F'

999: where copy_entity_txn_id = p_copy_entity_txn_id
1000: -- and trt.table_route_id = cpe.table_route_id
1001: and ( -- c_mirror_src_entity_result_id is null or
1002: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1003: -- and trt.where_clause = 'BEN_LER_ENRT_CTFN_F'
1004: and cpe.table_alias = c_table_alias
1005: and information1 = c_ler_enrt_ctfn_id
1006: -- and information4 = lnc.business_group_id
1007: and information2 = lnc.effective_start_date

Line 1013: -- END OF BEN_LER_ENRT_CTFN_F ----------------------

1009: );
1010:
1011: l_out_lnc_result_id number(15);
1012: ---------------------------------------------------------------
1013: -- END OF BEN_LER_ENRT_CTFN_F ----------------------
1014: ---------------------------------------------------------------
1015: ---------------------------------------------------------------
1016: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
1017: ---------------------------------------------------------------

Line 4823: -- START OF BEN_LER_ENRT_CTFN_F ----------------------

4819: );
4820: end loop;
4821: --
4822: ---------------------------------------------------------------
4823: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
4824: ---------------------------------------------------------------
4825: --
4826: for l_parent_rec in c_lnc_from_parent(l_LER_RQRS_ENRT_CTFN_ID) loop
4827: --

Line 4930: -- END OF BEN_LER_ENRT_CTFN_F ----------------------

4926: end loop;
4927: --
4928: end loop;
4929: ---------------------------------------------------------------
4930: -- END OF BEN_LER_ENRT_CTFN_F ----------------------
4931: ---------------------------------------------------------------
4932: end loop;
4933: ---------------------------------------------------------------
4934: -- END OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------

Line 10343: -- START OF BEN_LER_ENRT_CTFN_F ----------------------

10339: ---------------------------------------------------------------
10340: -- END OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
10341: ---------------------------------------------------------------
10342: ---------------------------------------------------------------
10343: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
10344: ---------------------------------------------------------------
10345: cursor c_lnc1_from_parent(c_LER_RQRS_ENRT_CTFN_ID number) is
10346: select ler_enrt_ctfn_id
10347: from BEN_LER_ENRT_CTFN_F

Line 10347: from BEN_LER_ENRT_CTFN_F

10343: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
10344: ---------------------------------------------------------------
10345: cursor c_lnc1_from_parent(c_LER_RQRS_ENRT_CTFN_ID number) is
10346: select ler_enrt_ctfn_id
10347: from BEN_LER_ENRT_CTFN_F
10348: where LER_RQRS_ENRT_CTFN_ID = c_LER_RQRS_ENRT_CTFN_ID ;
10349: --
10350: cursor c_lnc1(c_ler_enrt_ctfn_id number,c_mirror_src_entity_result_id number, c_table_alias varchar2) is
10351: select lnc.*

Line 10352: from BEN_LER_ENRT_CTFN_F lnc

10348: where LER_RQRS_ENRT_CTFN_ID = c_LER_RQRS_ENRT_CTFN_ID ;
10349: --
10350: cursor c_lnc1(c_ler_enrt_ctfn_id number,c_mirror_src_entity_result_id number, c_table_alias varchar2) is
10351: select lnc.*
10352: from BEN_LER_ENRT_CTFN_F lnc
10353: where lnc.ler_enrt_ctfn_id = c_ler_enrt_ctfn_id
10354: -- and lnc.business_group_id = p_business_group_id
10355: and not exists (
10356: select /*+ */ null

Line 10363: -- and trt.where_clause = 'BEN_LER_ENRT_CTFN_F'

10359: where copy_entity_txn_id = p_copy_entity_txn_id
10360: -- and trt.table_route_id = cpe.table_route_id
10361: and ( -- c_mirror_src_entity_result_id is null or
10362: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10363: -- and trt.where_clause = 'BEN_LER_ENRT_CTFN_F'
10364: and cpe.table_alias = c_table_alias
10365: and information1 = c_ler_enrt_ctfn_id
10366: -- and information4 = lnc.business_group_id
10367: and information2 = lnc.effective_start_date

Line 10372: -- END OF BEN_LER_ENRT_CTFN_F ----------------------

10368: and information3 = lnc.effective_end_date
10369: );
10370: l_out_lnc_result_id number(15);
10371: ---------------------------------------------------------------
10372: -- END OF BEN_LER_ENRT_CTFN_F ----------------------
10373: ---------------------------------------------------------------
10374:
10375: cursor c_opt1_from_parent(c_OIPL_ID number) is
10376: select distinct opt_id

Line 11415: -- START OF BEN_LER_ENRT_CTFN_F ----------------------

11411: );
11412: end loop ;
11413:
11414: ---------------------------------------------------------------
11415: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
11416: ---------------------------------------------------------------
11417: --
11418: for l_parent_rec in c_lnc1_from_parent(l_LER_RQRS_ENRT_CTFN_ID) loop
11419: --

Line 11510: -- END OF BEN_LER_ENRT_CTFN_F ----------------------

11506: end loop;
11507: --
11508: end loop;
11509: ---------------------------------------------------------------
11510: -- END OF BEN_LER_ENRT_CTFN_F ----------------------
11511: ---------------------------------------------------------------
11512: end loop;
11513: ---------------------------------------------------------------
11514: -- END OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------