APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_BNFT_RSTRN_CTFN_F

Line 4542: -- and tr.where_clause = l_BEN_BNFT_RSTRN_CTFN_F

4538: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4539: pqh_table_route tr
4540: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4541: and cpe.table_route_id = tr.table_route_id
4542: -- and tr.where_clause = l_BEN_BNFT_RSTRN_CTFN_F
4543: and tr.table_alias = l_table_alias
4544: and cpe.number_of_copies = 1 -- ADDITION
4545: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4546: order by information1, information2; --added for bug: 5151945

Line 4580: from BEN_BNFT_RSTRN_CTFN_F BRC

4576: c_business_group_id number,
4577: c_new_pk_id number) is
4578: select
4579: BRC.bnft_rstrn_ctfn_id new_value
4580: from BEN_BNFT_RSTRN_CTFN_F BRC
4581: where
4582: BRC.PL_ID = l_PL_ID and
4583: nvl(BRC.ENRT_CTFN_TYP_CD, 'XXX') = nvl(l_ENRT_CTFN_TYP_CD, 'XXX') and
4584: BRC.business_group_id = c_business_group_id

Line 4592: from BEN_BNFT_RSTRN_CTFN_F BRC1

4588: and effective_end_date ;
4589: --END TEMPIK
4590: /*TEMPIK
4591: and exists ( select null
4592: from BEN_BNFT_RSTRN_CTFN_F BRC1
4593: where
4594: BRC1.PL_ID = l_PL_ID and
4595: BRC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4596: BRC1.business_group_id = c_business_group_id

Line 4599: from BEN_BNFT_RSTRN_CTFN_F BRC2

4595: BRC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4596: BRC1.business_group_id = c_business_group_id
4597: and BRC1.effective_start_date <= c_effective_start_date )
4598: and exists ( select null
4599: from BEN_BNFT_RSTRN_CTFN_F BRC2
4600: where
4601: BRC2.PL_ID = l_PL_ID and
4602: BRC2.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
4603: BRC2.business_group_id = c_business_group_id

Line 4741: (p_base_table_name => 'BEN_BNFT_RSTRN_CTFN_F',

4737: if c_find_BRC_in_target%found then
4738: --
4739: --TEMPIK
4740: l_dt_rec_found := dt_api.check_min_max_dates
4741: (p_base_table_name => 'BEN_BNFT_RSTRN_CTFN_F',
4742: p_base_key_column => 'BNFT_RSTRN_CTFN_ID',
4743: p_base_key_value => l_new_value,
4744: p_from_date => l_min_esd,
4745: p_to_date => l_max_eed );

Line 4800: hr_utility.set_location(' BEN_BNFT_RSTRN_CTFN_F CREATE_BNFT_RSTRN_CTFN ',20);

4796: l_effective_date := ben_pd_copy_to_ben_one.g_copy_effective_date;
4797: end if;
4798: if l_first_rec and not l_update then
4799: -- Call Create routine.
4800: hr_utility.set_location(' BEN_BNFT_RSTRN_CTFN_F CREATE_BNFT_RSTRN_CTFN ',20);
4801: BEN_BNFT_RSTRN_CTFN_API.CREATE_BNFT_RSTRN_CTFN(
4802: --
4803: P_VALIDATE => false
4804: ,P_EFFECTIVE_DATE => l_effective_date

Line 4867: hr_utility.set_location(' BEN_BNFT_RSTRN_CTFN_F UPDATE_BNFT_RSTRN_CTFN ',30);

4863: else
4864: --
4865: -- Call Update routine for the pk_id created in prev run .
4866: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
4867: hr_utility.set_location(' BEN_BNFT_RSTRN_CTFN_F UPDATE_BNFT_RSTRN_CTFN ',30);
4868: --UPD START
4869: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
4870: --
4871: if l_update then