APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_PL_F

Line 365: ben_pl_typ_opt_typ_f pto, ben_oipl_f oipl, ben_pl_f pln

361:
362: select
363: pln.name name into l_information185
364: from
365: ben_pl_typ_opt_typ_f pto, ben_oipl_f oipl, ben_pl_f pln
366: where
367: pto.business_group_id = l_business_group_id
368: and p_effective_date between pto.effective_start_date and pto.effective_end_date
369: and oipl.oipl_id = l_crit.information258

Line 867: l_pl_id ben_pl_f.pl_id%type ;

863: l_new_enrt_cd ben_copy_entity_results.information101%type;
864: l_cur_enrt_cd ben_copy_entity_results.information102%type;
865:
866: plipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
867: l_pl_id ben_pl_f.pl_id%type ;
868:
869: l_new_dflt_enrt_cd varchar2(15);
870: l_old_dflt_enrt_cd varchar2(15);
871: l_default_object_id Number;

Line 1295: from BEN_PL_F pln

1291: p_copy_entity_result_id OUT NOCOPY NUMBER,
1292: p_ptp_copy_entity_result_id OUT NOCOPY NUMBER) IS
1293: cursor c_pln IS
1294: select pln.*
1295: from BEN_PL_F pln
1296: where pln.pl_id = p_pl_id
1297: and p_effective_date between effective_start_date and effective_end_date
1298: and NOT EXISTS (SELECT information1
1299: FROM BEN_COPY_ENTITY_RESULTS cer

Line 1305: l_pln_rec BEN_PL_F%ROWTYPE;

1301: AND table_alias = 'PLN'
1302: AND information1 = p_pl_id
1303: AND dml_operation = 'REUSE');
1304:
1305: l_pln_rec BEN_PL_F%ROWTYPE;
1306: l_copy_entity_result_id NUMBER;
1307: l_ptp_copy_entity_result_id NUMBER;
1308: l_result_type_cd VARCHAR2(30) := 'HIDE';
1309: l_mirror_src_entity_result_id NUMBER;

Line 3946: ben_pl_f

3942:
3943: select
3944: name into l_name
3945: from
3946: ben_pl_f
3947: where
3948: pl_id = p_information1
3949: and business_group_id = l_bg_id
3950: and l_effective_date between effective_start_date and effective_end_date;