APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_ENRT_CTFN_F

Line 15014: -- and tr.where_clause = l_BEN_ENRT_CTFN_F

15010: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15011: pqh_table_route tr
15012: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15013: and cpe.table_route_id = tr.table_route_id
15014: -- and tr.where_clause = l_BEN_ENRT_CTFN_F
15015: and tr.table_alias = l_table_alias
15016: and cpe.number_of_copies = 1 -- ADDITION
15017: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15018: order by information1, information2; --added for bug: 5151945

Line 15052: from BEN_ENRT_CTFN_F ECF

15048: c_business_group_id number,
15049: c_new_pk_id number) is
15050: select
15051: ECF.enrt_ctfn_id new_value
15052: from BEN_ENRT_CTFN_F ECF
15053: where
15054: nvl(ECF.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
15055: nvl(ECF.PL_ID,-999) = nvl(l_PL_ID,-999) and
15056: nvl(ECF.ENRT_CTFN_TYP_CD,'XXX') = nvl(l_ENRT_CTFN_TYP_CD,'XXX') and

Line 15065: from BEN_ENRT_CTFN_F ECF1

15061: and effective_end_date ;
15062: --END TEMPIK
15063: /*TEMPIK
15064: and exists ( select null
15065: from BEN_ENRT_CTFN_F ECF1
15066: where
15067: nvl(ECF1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
15068: nvl(ECF1.PL_ID,-999) = nvl(l_PL_ID,-999) and
15069: ECF1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and

Line 15073: from BEN_ENRT_CTFN_F ECF2

15069: ECF1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
15070: ECF1.business_group_id = c_business_group_id
15071: and ECF1.effective_start_date <= c_effective_start_date )
15072: and exists ( select null
15073: from BEN_ENRT_CTFN_F ECF2
15074: where
15075: nvl(ECF2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
15076: nvl(ECF2.PL_ID,-999) = nvl(l_PL_ID,-999) and
15077: ECF2.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and

Line 15222: (p_base_table_name => 'BEN_ENRT_CTFN_F',

15218: if c_find_ECF_in_target%found then
15219: --
15220: --TEMPIK
15221: l_dt_rec_found := dt_api.check_min_max_dates
15222: (p_base_table_name => 'BEN_ENRT_CTFN_F',
15223: p_base_key_column => 'ENRT_CTFN_ID',
15224: p_base_key_value => l_new_value,
15225: p_from_date => l_min_esd,
15226: p_to_date => l_max_eed );

Line 15281: hr_utility.set_location(' BEN_ENRT_CTFN_F CREATE_ENRT_CTFN ',20);

15277: end if;
15278:
15279: if l_first_rec and not l_update then
15280: -- Call Create routine.
15281: hr_utility.set_location(' BEN_ENRT_CTFN_F CREATE_ENRT_CTFN ',20);
15282: BEN_ENRT_CTFN_API.CREATE_ENRT_CTFN(
15283: --
15284: P_VALIDATE => false
15285: ,P_EFFECTIVE_DATE => l_effective_date

Line 15349: hr_utility.set_location(' BEN_ENRT_CTFN_F UPDATE_ENRT_CTFN ',30);

15345: else
15346: --
15347: -- Call Update routine for the pk_id created in prev run .
15348: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
15349: hr_utility.set_location(' BEN_ENRT_CTFN_F UPDATE_ENRT_CTFN ',30);
15350: --UPD START
15351: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15352: --
15353: if l_update then