APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 19811: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F

19807: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19808: pqh_table_route tr
19809: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19810: and cpe.table_route_id = tr.table_route_id
19811: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19812: and tr.table_alias = l_table_alias
19813: and cpe.number_of_copies = 1 -- ADDITION
19814: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
19815: order by information1, information2; --added for bug: 5151945

Line 19849: from BEN_PGM_DPNT_CVG_CTFN_F PGC

19845: c_business_group_id number,
19846: c_new_pk_id number) is
19847: select
19848: PGC.pgm_dpnt_cvg_ctfn_id new_value
19849: from BEN_PGM_DPNT_CVG_CTFN_F PGC
19850: where
19851: PGC.PGM_ID = l_PGM_ID and
19852: PGC.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19853: PGC.business_group_id = c_business_group_id

Line 19861: from BEN_PGM_DPNT_CVG_CTFN_F PGC1

19857: and effective_end_date ;
19858: --END TEMPIK
19859: /*TEMPIK
19860: and exists ( select null
19861: from BEN_PGM_DPNT_CVG_CTFN_F PGC1
19862: where
19863: PGC1.PGM_ID = l_PGM_ID and
19864: PGC1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19865: PGC1.business_group_id = c_business_group_id

Line 19868: from BEN_PGM_DPNT_CVG_CTFN_F PGC2

19864: PGC1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19865: PGC1.business_group_id = c_business_group_id
19866: and PGC1.effective_start_date <= c_effective_start_date )
19867: and exists ( select null
19868: from BEN_PGM_DPNT_CVG_CTFN_F PGC2
19869: where
19870: PGC2.PGM_ID = l_PGM_ID and
19871: PGC2.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19872: PGC2.business_group_id = c_business_group_id

Line 20013: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',

20009: if c_find_PGC_in_target%found then
20010: --
20011: --TEMPIK
20012: l_dt_rec_found := dt_api.check_min_max_dates
20013: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',
20014: p_base_key_column => 'PGM_DPNT_CVG_CTFN_ID',
20015: p_base_key_value => l_new_value,
20016: p_from_date => l_min_esd,
20017: p_to_date => l_max_eed );

Line 20072: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F CREATE_PROGRAM_DPNT_CVG_CTFN ',20);

20068: end if;
20069:
20070: if l_first_rec and not l_update then
20071: -- Call Create routine.
20072: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F CREATE_PROGRAM_DPNT_CVG_CTFN ',20);
20073: BEN_PROGRAM_DPNT_CVG_CTFN_API.CREATE_PROGRAM_DPNT_CVG_CTFN(
20074: --
20075: P_VALIDATE => false
20076: ,P_EFFECTIVE_DATE => l_effective_date

Line 20142: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F UPDATE_PROGRAM_DPNT_CVG_CTFN ',30);

20138: else
20139: --
20140: -- Call Update routine for the pk_id created in prev run .
20141: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
20142: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F UPDATE_PROGRAM_DPNT_CVG_CTFN ',30);
20143: --UPD START
20144: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
20145: --
20146: if l_update then