APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 19724: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F

19720: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19721: pqh_table_route tr
19722: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19723: and cpe.table_route_id = tr.table_route_id
19724: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19725: and tr.table_alias = l_table_alias
19726: and cpe.number_of_copies = 1 -- ADDITION
19727: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
19728: order by information1, information2; --added for bug: 5151945

Line 19762: from BEN_PGM_DPNT_CVG_CTFN_F PGC

19758: c_business_group_id number,
19759: c_new_pk_id number) is
19760: select
19761: PGC.pgm_dpnt_cvg_ctfn_id new_value
19762: from BEN_PGM_DPNT_CVG_CTFN_F PGC
19763: where
19764: PGC.PGM_ID = l_PGM_ID and
19765: PGC.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19766: PGC.business_group_id = c_business_group_id

Line 19774: from BEN_PGM_DPNT_CVG_CTFN_F PGC1

19770: and effective_end_date ;
19771: --END TEMPIK
19772: /*TEMPIK
19773: and exists ( select null
19774: from BEN_PGM_DPNT_CVG_CTFN_F PGC1
19775: where
19776: PGC1.PGM_ID = l_PGM_ID and
19777: PGC1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19778: PGC1.business_group_id = c_business_group_id

Line 19781: from BEN_PGM_DPNT_CVG_CTFN_F PGC2

19777: PGC1.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19778: PGC1.business_group_id = c_business_group_id
19779: and PGC1.effective_start_date <= c_effective_start_date )
19780: and exists ( select null
19781: from BEN_PGM_DPNT_CVG_CTFN_F PGC2
19782: where
19783: PGC2.PGM_ID = l_PGM_ID and
19784: PGC2.DPNT_CVG_CTFN_TYP_CD = l_DPNT_CVG_CTFN_TYP_CD and
19785: PGC2.business_group_id = c_business_group_id

Line 19926: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',

19922: if c_find_PGC_in_target%found then
19923: --
19924: --TEMPIK
19925: l_dt_rec_found := dt_api.check_min_max_dates
19926: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',
19927: p_base_key_column => 'PGM_DPNT_CVG_CTFN_ID',
19928: p_base_key_value => l_new_value,
19929: p_from_date => l_min_esd,
19930: p_to_date => l_max_eed );

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

19981: end if;
19982:
19983: if l_first_rec and not l_update then
19984: -- Call Create routine.
19985: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F CREATE_PROGRAM_DPNT_CVG_CTFN ',20);
19986: BEN_PROGRAM_DPNT_CVG_CTFN_API.CREATE_PROGRAM_DPNT_CVG_CTFN(
19987: --
19988: P_VALIDATE => false
19989: ,P_EFFECTIVE_DATE => l_effective_date

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

20051: else
20052: --
20053: -- Call Update routine for the pk_id created in prev run .
20054: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
20055: hr_utility.set_location(' BEN_PGM_DPNT_CVG_CTFN_F UPDATE_PROGRAM_DPNT_CVG_CTFN ',30);
20056: --UPD START
20057: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
20058: --
20059: if l_update then