APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_PL_TYP_F

Line 28: from BEN_PL_TYP_F ptp

24: p_copy_entity_result_id OUT NOCOPY NUMBER) is
25: l_proc varchar2(72) := g_package||'.copy_pl_typ_record';
26: cursor c_ptp IS
27: select ptp.*
28: from BEN_PL_TYP_F ptp
29: where ptp.pl_typ_id = p_pl_typ_id
30: -- and p_effective_date between effective_start_date and effective_end_date
31: and NOT EXISTS (SELECT information1
32: FROM BEN_COPY_ENTITY_RESULTS cer

Line 38: l_ptp_rec BEN_PL_TYP_F%ROWTYPE;

34: AND table_alias = 'PTP'
35: AND information1 = p_pl_typ_id
36: AND dml_operation = 'REUSE');
37:
38: l_ptp_rec BEN_PL_TYP_F%ROWTYPE;
39: l_copy_entity_result_id NUMBER;
40: l_result_type_cd VARCHAR2(30) := 'DISPLAY';
41: l_mirror_src_entity_result_id NUMBER;
42: l_number_of_copies NUMBER := 0;

Line 349: ben_pl_typ_opt_typ_f pto, ben_pl_typ_f ptp, ben_opt_f opt

345: /* mapping not required
346: select
347: ptp.name || ' - ' || opt.name name into l_name
348: from
349: ben_pl_typ_opt_typ_f pto, ben_pl_typ_f ptp, ben_opt_f opt
350: where
351: pto.business_group_id = l_business_group_id
352: and pto.pl_typ_opt_typ_id = l_crit.information228
353: and p_effective_date between pto.effective_start_date and pto.effective_end_date

Line 2529: ben_pl_typ_f ptp

2525: pgm.name || ' - ' || ptp.name into l_overview_name
2526: from
2527: ben_pgm_f pgm,
2528: ben_ptip_f ctp,
2529: ben_pl_typ_f ptp
2530: where
2531: ctp.business_group_id = l_business_group_id
2532: and ctp.ptip_id = p_ctp_id
2533: and ctp.pgm_id = pgm.pgm_id

Line 4470: l_ptp_id ben_pl_typ_f.pl_typ_id%type;

4466:
4467: l_new_enrt_cd ben_copy_entity_results.information101%type;
4468: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4469: ptipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
4470: l_ptp_id ben_pl_typ_f.pl_typ_id%type;
4471: l_new_dflt_enrt_cd varchar2(15);
4472: l_old_dflt_enrt_cd varchar2(15);
4473: l_default_object_id Number;
4474: --