APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 16364: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F

16360: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16361: pqh_table_route tr
16362: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16363: and cpe.table_route_id = tr.table_route_id
16364: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F
16365: and tr.table_alias = l_table_alias
16366: and cpe.number_of_copies = 1 -- ADDITION
16367: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
16368: order by information1, information2; --added for bug: 5151945

Line 16402: from BEN_POPL_ENRT_TYP_CYCL_F PET

16398: c_business_group_id number,
16399: c_new_pk_id number) is
16400: select
16401: PET.popl_enrt_typ_cycl_id new_value
16402: from BEN_POPL_ENRT_TYP_CYCL_F PET
16403: where
16404: nvl(PET.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
16405: nvl(PET.PL_ID,-999) = nvl(l_PL_ID,-999) and
16406: PET.ENRT_TYP_CYCL_CD = l_ENRT_TYP_CYCL_CD and

Line 16415: from BEN_POPL_ENRT_TYP_CYCL_F PET1

16411: and effective_end_date ;
16412: --END TEMPIK
16413: /*TEMPIK
16414: and exists ( select null
16415: from BEN_POPL_ENRT_TYP_CYCL_F PET1
16416: where
16417: nvl(PET1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
16418: nvl(PET1.PL_ID,-999) = nvl(l_PL_ID,-999) and
16419: PET1.ENRT_TYP_CYCL_CD = l_ENRT_TYP_CYCL_CD and

Line 16423: from BEN_POPL_ENRT_TYP_CYCL_F PET2

16419: PET1.ENRT_TYP_CYCL_CD = l_ENRT_TYP_CYCL_CD and
16420: PET1.business_group_id = c_business_group_id
16421: and PET1.effective_start_date <= c_effective_start_date )
16422: and exists ( select null
16423: from BEN_POPL_ENRT_TYP_CYCL_F PET2
16424: where
16425: nvl(PET2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
16426: nvl(PET2.PL_ID,-999) = nvl(l_PL_ID,-999) and
16427: PET2.ENRT_TYP_CYCL_CD = l_ENRT_TYP_CYCL_CD and

Line 16569: (p_base_table_name => 'BEN_POPL_ENRT_TYP_CYCL_F',

16565: if c_find_PET_in_target%found then
16566: --
16567: --TEMPIK
16568: l_dt_rec_found := dt_api.check_min_max_dates
16569: (p_base_table_name => 'BEN_POPL_ENRT_TYP_CYCL_F',
16570: p_base_key_column => 'POPL_ENRT_TYP_CYCL_ID',
16571: p_base_key_value => l_new_value,
16572: p_from_date => l_min_esd,
16573: p_to_date => l_max_eed );

Line 16628: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F CREATE_POPL_ENRT_TYP_CYCL ',20);

16624: end if;
16625:
16626: if l_first_rec and not l_update then
16627: -- Call Create routine.
16628: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F CREATE_POPL_ENRT_TYP_CYCL ',20);
16629: BEN_POPL_ENRT_TYP_CYCL_API.CREATE_POPL_ENRT_TYP_CYCL(
16630: --
16631: P_VALIDATE => false
16632: ,P_EFFECTIVE_DATE => l_effective_date

Line 16694: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F UPDATE_POPL_ENRT_TYP_CYCL ',30);

16690: else
16691: --
16692: -- Call Update routine for the pk_id created in prev run .
16693: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
16694: hr_utility.set_location(' BEN_POPL_ENRT_TYP_CYCL_F UPDATE_POPL_ENRT_TYP_CYCL ',30);
16695: --UPD START
16696: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
16697: --
16698: if l_update then

Line 28070: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows

28066:
28067: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28068: --TCS PDW Integration ENH
28069: --
28070: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows
28071: -- are created as part of leaf call and above call.
28072: --
28073: BEN_PD_COPY_TO_BEN_TWO.create_final_intersect_rows(
28074: p_validate => p_validate