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_PL_REGN_F

Line 818: -- START OF BEN_PL_REGN_F ----------------------

814: ---------------------------------------------------------------
815: -- END OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
816: ---------------------------------------------------------------
817: ---------------------------------------------------------------
818: -- START OF BEN_PL_REGN_F ----------------------
819: ---------------------------------------------------------------
820: cursor c_prg_from_parent(c_PL_ID number) is
821: select pl_regn_id
822: from BEN_PL_REGN_F

Line 822: from BEN_PL_REGN_F

818: -- START OF BEN_PL_REGN_F ----------------------
819: ---------------------------------------------------------------
820: cursor c_prg_from_parent(c_PL_ID number) is
821: select pl_regn_id
822: from BEN_PL_REGN_F
823: where PL_ID = c_PL_ID ;
824: --
825: cursor c_prg(c_pl_regn_id number,c_mirror_src_entity_result_id number,
826: c_table_alias varchar2) is

Line 828: from BEN_PL_REGN_F prg

824: --
825: cursor c_prg(c_pl_regn_id number,c_mirror_src_entity_result_id number,
826: c_table_alias varchar2) is
827: select prg.*
828: from BEN_PL_REGN_F prg
829: where prg.pl_regn_id = c_pl_regn_id
830: -- and prg.business_group_id = p_business_group_id
831: and not exists (
832: select /*+ */ null

Line 839: -- and trt.where_clause = 'BEN_PL_REGN_F'

835: where copy_entity_txn_id = p_copy_entity_txn_id
836: -- and trt.table_route_id = cpe.table_route_id
837: and ( -- c_mirror_src_entity_result_id is null or
838: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
839: -- and trt.where_clause = 'BEN_PL_REGN_F'
840: and cpe.table_alias = c_table_alias
841: and information1 = c_pl_regn_id
842: -- and information4 = prg.business_group_id
843: and information2 = prg.effective_start_date

Line 848: -- END OF BEN_PL_REGN_F ----------------------

844: and information3 = prg.effective_end_date
845: );
846: l_out_prg_result_id number ;
847: ---------------------------------------------------------------
848: -- END OF BEN_PL_REGN_F ----------------------
849: ---------------------------------------------------------------
850: ---------------------------------------------------------------
851: -- START OF BEN_REGN_F ----------------------
852: ---------------------------------------------------------------

Line 855: from BEN_PL_REGN_F

851: -- START OF BEN_REGN_F ----------------------
852: ---------------------------------------------------------------
853: cursor c_reg_from_parent(c_PL_REGN_ID number) is
854: select regn_id
855: from BEN_PL_REGN_F
856: where PL_REGN_ID = c_PL_REGN_ID ;
857: --
858: cursor c_reg(c_regn_id number,c_mirror_src_entity_result_id number,
859: c_table_alias varchar2) is

Line 889: from BEN_PL_REGN_F

885: -- START OF BEN_RPTG_GRP ----------------------
886: ---------------------------------------------------------------
887: cursor c_bnr_from_parent(c_PL_REGN_ID number) is
888: select rptg_grp_id
889: from BEN_PL_REGN_F
890: where PL_REGN_ID = c_PL_REGN_ID ;
891: --
892: cursor c_bnr(c_rptg_grp_id number,c_mirror_src_entity_result_id number,
893: c_table_alias varchar2) is

Line 1122: -- START OF BEN_PL_REGN_F ----------------------

1118: from BEN_OIPL_F
1119: where PL_ID = c_PL_ID ;
1120: ---------------------------------------------------------------
1121: ---------------------------------------------------------------
1122: -- START OF BEN_PL_REGN_F ----------------------
1123: ---------------------------------------------------------------
1124: cursor c_prg1_from_parent(c_RPTG_GRP_ID number) is
1125: select pl_regn_id
1126: from BEN_PL_REGN_F

Line 1126: from BEN_PL_REGN_F

1122: -- START OF BEN_PL_REGN_F ----------------------
1123: ---------------------------------------------------------------
1124: cursor c_prg1_from_parent(c_RPTG_GRP_ID number) is
1125: select pl_regn_id
1126: from BEN_PL_REGN_F
1127: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
1128: --
1129: cursor c_prg1(c_pl_regn_id number,c_mirror_src_entity_result_id number,
1130: c_table_alias varchar2) is

Line 1132: from BEN_PL_REGN_F prg

1128: --
1129: cursor c_prg1(c_pl_regn_id number,c_mirror_src_entity_result_id number,
1130: c_table_alias varchar2) is
1131: select prg.*
1132: from BEN_PL_REGN_F prg
1133: where prg.pl_regn_id = c_pl_regn_id
1134: -- and prg.business_group_id = p_business_group_id
1135: and not exists (
1136: select /*+ */ null

Line 1143: -- and trt.where_clause = 'BEN_PL_REGN_F'

1139: where copy_entity_txn_id = p_copy_entity_txn_id
1140: -- and trt.table_route_id = cpe.table_route_id
1141: and ( -- c_mirror_src_entity_result_id is null or
1142: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1143: -- and trt.where_clause = 'BEN_PL_REGN_F'
1144: and cpe.table_alias = c_table_alias
1145: and information1 = c_pl_regn_id
1146: -- and information4 = prg.business_group_id
1147: and information2 = prg.effective_start_date

Line 1153: -- END OF BEN_PL_REGN_F ----------------------

1149: );
1150:
1151: l_out_prg1_result_id number ;
1152: ---------------------------------------------------------------
1153: -- END OF BEN_PL_REGN_F ----------------------
1154: ---------------------------------------------------------------
1155: ---------------------------------------------------------------
1156: -- START OF BEN_PL_REGY_BOD_F ----------------------
1157: ---------------------------------------------------------------

Line 1261: from BEN_PL_REGN_F

1257: -- START OF BEN_REGN_F ----------------------
1258: ---------------------------------------------------------------
1259: cursor c_reg1_from_parent(c_PL_REGN_ID number) is
1260: select regn_id
1261: from BEN_PL_REGN_F
1262: where PL_REGN_ID = c_PL_REGN_ID ;
1263: --
1264: cursor c_reg1(c_regn_id number,c_mirror_src_entity_result_id number,
1265: c_table_alias varchar2) is

Line 2282: -- START OF BEN_PL_REGN_F ----------------------

2278: ---------------------------------------------------------------
2279: -- END OF BEN_PL_TYP_F ----------------------
2280: ---------------------------------------------------------------
2281: ---------------------------------------------------------------
2282: -- START OF BEN_PL_REGN_F ----------------------
2283: ---------------------------------------------------------------
2284: --
2285: for l_parent_rec in c_prg_from_parent(l_PL_ID) loop
2286: --

Line 2674: -- START OF BEN_PL_REGN_F ----------------------

2670:
2671: end loop;
2672:
2673: ---------------------------------------------------------------
2674: -- START OF BEN_PL_REGN_F ----------------------
2675: ---------------------------------------------------------------
2676: --
2677: for l_parent_rec in c_prg1_from_parent(l_RPTG_GRP_ID) loop
2678: --

Line 2904: -- END OF BEN_PL_REGN_F ----------------------

2900: -- END OF BEN_REGN_F ----------------------
2901: ---------------------------------------------------------------
2902: end loop;
2903: ---------------------------------------------------------------
2904: -- END OF BEN_PL_REGN_F ----------------------
2905: ---------------------------------------------------------------
2906: ---------------------------------------------------------------
2907: -- START OF BEN_PL_REGY_BOD_F ----------------------
2908: ---------------------------------------------------------------

Line 3119: -- END OF BEN_PL_REGN_F ----------------------

3115: -- END OF BEN_RPTG_GRP ----------------------
3116: ---------------------------------------------------------------
3117: end loop;
3118: ---------------------------------------------------------------
3119: -- END OF BEN_PL_REGN_F ----------------------
3120: ---------------------------------------------------------------
3121: -- ------------------------------------------------------------------------
3122: -- BEN_PL_GD_SVC_F
3123: -- -------------------------------------------------------------------------

Line 6479: -- START OF BEN_PL_REGN_F ----------------------

6475: ---------------------------------------------------------------
6476: -- END OF BEN_ACTN_TYP ----------------------
6477: ---------------------------------------------------------------
6478: ---------------------------------------------------------------
6479: -- START OF BEN_PL_REGN_F ----------------------
6480: ---------------------------------------------------------------
6481: cursor c_prg_from_parent(c_RPTG_GRP_ID number) is
6482: select pl_regn_id
6483: from BEN_PL_REGN_F

Line 6483: from BEN_PL_REGN_F

6479: -- START OF BEN_PL_REGN_F ----------------------
6480: ---------------------------------------------------------------
6481: cursor c_prg_from_parent(c_RPTG_GRP_ID number) is
6482: select pl_regn_id
6483: from BEN_PL_REGN_F
6484: where RPTG_GRP_ID = c_RPTG_GRP_ID ;
6485: --
6486: cursor c_prg(c_pl_regn_id number,c_mirror_src_entity_result_id number,
6487: c_table_alias varchar2) is

Line 6489: from BEN_PL_REGN_F prg

6485: --
6486: cursor c_prg(c_pl_regn_id number,c_mirror_src_entity_result_id number,
6487: c_table_alias varchar2) is
6488: select prg.*
6489: from BEN_PL_REGN_F prg
6490: where prg.pl_regn_id = c_pl_regn_id
6491: -- and prg.business_group_id = p_business_group_id
6492: and not exists (
6493: select /*+ */ null

Line 6500: -- and trt.where_clause = 'BEN_PL_REGN_F'

6496: where copy_entity_txn_id = p_copy_entity_txn_id
6497: -- and trt.table_route_id = cpe.table_route_id
6498: and ( -- c_mirror_src_entity_result_id is null or
6499: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6500: -- and trt.where_clause = 'BEN_PL_REGN_F'
6501: and cpe.table_alias = c_table_alias
6502: and information1 = c_pl_regn_id
6503: -- and information4 = prg.business_group_id
6504: and information2 = prg.effective_start_date

Line 6510: -- END OF BEN_PL_REGN_F ----------------------

6506: );
6507: l_pl_regn_id number(15);
6508: l_out_prg_result_id number(15);
6509: ---------------------------------------------------------------
6510: -- END OF BEN_PL_REGN_F ----------------------
6511: ---------------------------------------------------------------
6512: ---------------------------------------------------------------
6513: -- START OF BEN_PL_REGY_BOD_F ----------------------
6514: ---------------------------------------------------------------

Line 6617: from BEN_PL_REGN_F

6613: -- START OF BEN_REGN_F ----------------------
6614: ---------------------------------------------------------------
6615: cursor c_reg_from_parent(c_PL_REGN_ID number) is
6616: select regn_id
6617: from BEN_PL_REGN_F
6618: where PL_REGN_ID = c_PL_REGN_ID ;
6619: --
6620: cursor c_reg(c_regn_id number,c_mirror_src_entity_result_id number,
6621: c_table_alias varchar2) is

Line 8539: -- START OF BEN_PL_REGN_F ----------------------

8535:
8536: end loop;
8537: --
8538: ---------------------------------------------------------------
8539: -- START OF BEN_PL_REGN_F ----------------------
8540: ---------------------------------------------------------------
8541: --
8542: for l_parent_rec in c_prg_from_parent(l_RPTG_GRP_ID) loop
8543: --

Line 8771: -- END OF BEN_PL_REGN_F ----------------------

8767: -- END OF BEN_REGN_F ----------------------
8768: ---------------------------------------------------------------
8769: end loop;
8770: ---------------------------------------------------------------
8771: -- END OF BEN_PL_REGN_F ----------------------
8772: ---------------------------------------------------------------
8773: ---------------------------------------------------------------
8774: -- START OF BEN_PL_REGY_BOD_F ----------------------
8775: ---------------------------------------------------------------