APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_ACTY_BASE_RT_CTFN_F

Line 14973: l_ENRT_CTFN_TYP_CD ben_acty_base_rt_ctfn_f.enrt_ctfn_typ_cd%type;

14969: ) is
14970: --
14971: l_ACTY_BASE_RT_ID number;
14972: l_CTFN_RQD_WHEN_RL number;
14973: l_ENRT_CTFN_TYP_CD ben_acty_base_rt_ctfn_f.enrt_ctfn_typ_cd%type;
14974:
14975: cursor c_unique_ABC(l_table_alias varchar2) is
14976: select distinct cpe.information1,
14977: cpe.information2,

Line 14985: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_CTFN_F

14981: from ben_copy_entity_results cpe,
14982: pqh_table_route tr
14983: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14984: and cpe.table_route_id = tr.table_route_id
14985: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_CTFN_F
14986: and tr.table_alias = l_table_alias
14987: and cpe.number_of_copies = 1 -- ADDITION
14988: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14989: order by information1, information2; --added for bug: 5151945

Line 15023: from BEN_ACTY_BASE_RT_CTFN_F ABC

15019: c_business_group_id number,
15020: c_new_pk_id number) is
15021: select
15022: ABC.acty_base_rt_ctfn_id new_value
15023: from BEN_ACTY_BASE_RT_CTFN_F ABC
15024: where
15025: ABC.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
15026: ABC.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
15027: ABC.business_group_id = c_business_group_id

Line 15035: from BEN_ACTY_BASE_RT_CTFN_F ABC1

15031: and effective_end_date ;
15032: --END TEMPIK
15033: /*TEMPIK
15034: and exists ( select null
15035: from BEN_ACTY_BASE_RT_CTFN_F ABC1
15036: where
15037: ABC1.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
15038: ABC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
15039: ABC1.business_group_id = c_business_group_id

Line 15042: from BEN_ACTY_BASE_RT_CTFN_F ABC2

15038: ABC1.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
15039: ABC1.business_group_id = c_business_group_id
15040: and ABC1.effective_start_date <= c_effective_start_date )
15041: and exists ( select null
15042: from BEN_ACTY_BASE_RT_CTFN_F ABC2
15043: where
15044: ABC2.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
15045: ABC2.ENRT_CTFN_TYP_CD = l_ENRT_CTFN_TYP_CD and
15046: ABC2.business_group_id = c_business_group_id

Line 15194: (p_base_table_name => 'BEN_ACTY_BASE_RT_CTFN_F',

15190: fetch c_find_ABC_in_target into l_new_value ;
15191: if c_find_ABC_in_target%found then
15192: --TEMPIK
15193: l_dt_rec_found := dt_api.check_min_max_dates
15194: (p_base_table_name => 'BEN_ACTY_BASE_RT_CTFN_F',
15195: p_base_key_column => 'ACTY_BASE_RT_CTFN_ID',
15196: p_base_key_value => l_new_value,
15197: p_from_date => l_min_esd,
15198: p_to_date => l_max_eed );

Line 15256: hr_utility.set_location(' BEN_ACTY_BASE_RT_CTFN_F CREATE_ACTY_BASE_RT_CTFN ',20);

15252:
15253: --if l_first_rec then
15254: if l_first_rec and not l_update then
15255: -- Call Create routine.
15256: hr_utility.set_location(' BEN_ACTY_BASE_RT_CTFN_F CREATE_ACTY_BASE_RT_CTFN ',20);
15257: BEN_ACTY_BASE_RT_CTFN_API.CREATE_ACTY_BASE_RT_CTFN(
15258: --
15259: P_VALIDATE => false
15260: ,P_EFFECTIVE_DATE => l_effective_date

Line 15323: hr_utility.set_location(' BEN_ACTY_BASE_RT_CTFN_F UPDATE_ACTY_BASE_RT_CTFN ',30);

15319: else
15320: --
15321: -- Call Update routine for the pk_id created in prev run .
15322: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
15323: hr_utility.set_location(' BEN_ACTY_BASE_RT_CTFN_F UPDATE_ACTY_BASE_RT_CTFN ',30);
15324: --UPD START
15325: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15326: --
15327: if l_update then