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_TYP_F

Line 57: ben_pl_typ_f ptp,

53: hl.meaning Plan_Usage,
54: null Information8
55: from BEN_PLIP_F plip,
56: BEN_PL_F PLN,
57: ben_pl_typ_f ptp,
58: hr_lookups hl
59: where ( C_PLIP_ID is not null and plip.PLIP_ID = C_PLIP_ID )
60: and plip.pl_id=pln.pl_id
61: and pln.pl_typ_id = ptp.pl_typ_id

Line 70: ben_pl_typ_f ptp,

66: ptp.name pl_typ_name,
67: hl.meaning Plan_Usage,
68: 'PLNIP' Information8
69: from BEN_PL_F PLN,
70: ben_pl_typ_f ptp,
71: hr_lookups hl
72: where ( C_PL_ID is not null and pln.PL_ID = C_PL_ID )
73: and pln.pl_typ_id = ptp.pl_typ_id
74: and pln.pl_cd = hl.lookup_code

Line 177: -- START OF BEN_PL_TYP_F ----------------------

173:
174: l_pln_esd ben_pl_f.effective_start_date%type;
175:
176: ---------------------------------------------------------------
177: -- START OF BEN_PL_TYP_F ----------------------
178: ---------------------------------------------------------------
179: cursor c_ptp_from_parent(c_PL_ID number) is
180: select pl_typ_id
181: from BEN_PL_F

Line 188: -- END OF BEN_PL_TYP_F ----------------------

184:
185: l_pl_typ_id number(15);
186: l_out_ptp_result_id number(15);
187: ---------------------------------------------------------------
188: -- END OF BEN_PL_TYP_F ----------------------
189: ---------------------------------------------------------------
190: cursor c_vgs_from_parent(c_PL_ID number) is
191: select pl_gd_or_svc_id
192: from BEN_PL_GD_OR_SVC_F

Line 1351: l_pl_typ_name ben_pl_typ_f.name%type;

1347: L_OUT_DDR_RESULT_ID number(15);
1348: L_DSGN_RQMT_RLSHP_TYP_ID number(15);
1349: L_OUT_DRR_RESULT_ID number(15);
1350: --
1351: l_pl_typ_name ben_pl_typ_f.name%type;
1352: l_pl_usage hr_lookups.meaning%type;
1353: l_group_pl_id number (15);
1354: begin
1355: --

Line 2262: -- START OF BEN_PL_TYP_F ----------------------

2258: -- END OF BEN_CWB_WKSHT_GRP ----------------------
2259: ---------------------------------------------------------------
2260:
2261: ---------------------------------------------------------------
2262: -- START OF BEN_PL_TYP_F ----------------------
2263: ---------------------------------------------------------------
2264: --
2265: for l_parent_rec in c_ptp_from_parent(l_PL_ID) loop
2266: create_pl_typ_result

Line 2279: -- END OF BEN_PL_TYP_F ----------------------

2275: ,p_parent_entity_result_id => l_out_pln_cpp_result_id
2276: );
2277: end loop;
2278: ---------------------------------------------------------------
2279: -- END OF BEN_PL_TYP_F ----------------------
2280: ---------------------------------------------------------------
2281: ---------------------------------------------------------------
2282: -- START OF BEN_PL_REGN_F ----------------------
2283: ---------------------------------------------------------------

Line 11722: -- START OF BEN_PL_TYP_F ----------------------

11718: ---------------------------------------------------------------
11719: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
11720: ---------------------------------------------------------------
11721: ---------------------------------------------------------------
11722: -- START OF BEN_PL_TYP_F ----------------------
11723: ---------------------------------------------------------------
11724: cursor c_ptp1_from_parent(c_PL_TYP_OPT_TYP_ID number) is
11725: select distinct pl_typ_id
11726: from BEN_PL_TYP_OPT_TYP_F

Line 11730: -- END OF BEN_PL_TYP_F ----------------------

11726: from BEN_PL_TYP_OPT_TYP_F
11727: where PL_TYP_OPT_TYP_ID = c_PL_TYP_OPT_TYP_ID ;
11728: --
11729: ---------------------------------------------------------------
11730: -- END OF BEN_PL_TYP_F ----------------------
11731: ---------------------------------------------------------------
11732:
11733: cursor c_opt_exists(c_opt_id number,
11734: c_table_alias varchar2) is

Line 12262: -- START OF BEN_PL_TYP_F ----------------------

12258: --
12259: end loop;
12260: --
12261: ---------------------------------------------------------------
12262: -- START OF BEN_PL_TYP_F ----------------------
12263: ---------------------------------------------------------------
12264: --
12265: for l_parent_rec in c_ptp1_from_parent(l_PL_TYP_OPT_TYP_ID) loop
12266: create_pl_typ_result

Line 12279: -- END OF BEN_PL_TYP_F ----------------------

12275: ,p_parent_entity_result_id => l_out_pon_result_id
12276: );
12277: end loop;
12278: ---------------------------------------------------------------
12279: -- END OF BEN_PL_TYP_F ----------------------
12280: ---------------------------------------------------------------
12281: end loop;
12282: ---------------------------------------------------------------
12283: -- END OF BEN_PL_TYP_OPT_TYP_F ----------------------

Line 12333: -- START OF BEN_PL_TYP_F ----------------------

12329: -- from pqh_table_route trt
12330: -- where trt.table_alias = c_parent_table_alias;
12331: --
12332: ---------------------------------------------------------------
12333: -- START OF BEN_PL_TYP_F ----------------------
12334: ---------------------------------------------------------------
12335: cursor c_ptp(c_pl_typ_id number,c_mirror_src_entity_result_id number,
12336: c_table_alias varchar2) is
12337: select ptp.*

Line 12338: from BEN_PL_TYP_F ptp

12334: ---------------------------------------------------------------
12335: cursor c_ptp(c_pl_typ_id number,c_mirror_src_entity_result_id number,
12336: c_table_alias varchar2) is
12337: select ptp.*
12338: from BEN_PL_TYP_F ptp
12339: where ptp.pl_typ_id = c_pl_typ_id
12340: -- and ptp.business_group_id = p_business_group_id
12341: and not exists (
12342: select /*+ */ null

Line 12349: -- and trt.where_clause = 'BEN_PL_TYP_F'

12345: where copy_entity_txn_id = p_copy_entity_txn_id
12346: -- and trt.table_route_id = cpe.table_route_id
12347: and ( -- c_mirror_src_entity_result_id is null or
12348: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12349: -- and trt.where_clause = 'BEN_PL_TYP_F'
12350: and cpe.table_alias = c_table_alias
12351: and information1 = c_pl_typ_id
12352: -- and information4 = ptp.business_group_id
12353: and information2 = ptp.effective_start_date

Line 12360: -- END OF BEN_PL_TYP_F ----------------------

12356:
12357: l_pl_typ_id number(15);
12358: l_out_ptp_result_id number(15);
12359: ---------------------------------------------------------------
12360: -- END OF BEN_PL_TYP_F ----------------------
12361: ---------------------------------------------------------------
12362:
12363: cursor c_object_exists(c_pk_id number,
12364: c_table_alias varchar2) is

Line 12385: -- START OF BEN_PL_TYP_F ----------------------

12381:
12382: begin
12383: --
12384: ---------------------------------------------------------------
12385: -- START OF BEN_PL_TYP_F ----------------------
12386: ---------------------------------------------------------------
12387: --
12388: --
12389: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 12501: -- END OF BEN_PL_TYP_F ----------------------

12497: --
12498: end loop;
12499: --
12500: ---------------------------------------------------------------
12501: -- END OF BEN_PL_TYP_F ----------------------
12502: ---------------------------------------------------------------
12503: --
12504: end create_pl_typ_result ;
12505: --