APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_ACTY_RT_PYMT_SCHED_F

Line 14496: l_PYMT_SCHED_CD ben_acty_rt_pymt_sched_f.pymt_sched_cd%type;

14492: ) is
14493: --
14494: l_ACTY_BASE_RT_ID number;
14495: l_PYMT_SCHED_RL number;
14496: l_PYMT_SCHED_CD ben_acty_rt_pymt_sched_f.pymt_sched_cd%type;
14497: cursor c_unique_APF(l_table_alias varchar2) is
14498: select distinct cpe.information1,
14499: cpe.information2,
14500: cpe.information3,

Line 14507: -- and tr.where_clause = l_BEN_ACTY_RT_PYMT_SCHED_F

14503: from ben_copy_entity_results cpe,
14504: pqh_table_route tr
14505: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14506: and cpe.table_route_id = tr.table_route_id
14507: -- and tr.where_clause = l_BEN_ACTY_RT_PYMT_SCHED_F
14508: and tr.table_alias = l_table_alias
14509: and cpe.number_of_copies = 1
14510: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14511: order by information1, information2; --added for bug: 5151945

Line 14545: from BEN_ACTY_RT_PYMT_SCHED_F APF

14541: c_business_group_id number,
14542: c_new_pk_id number) is
14543: select
14544: APF.acty_rt_pymt_sched_id new_value
14545: from BEN_ACTY_RT_PYMT_SCHED_F APF
14546: where
14547: APF.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
14548: APF.PYMT_SCHED_CD = l_PYMT_SCHED_CD and
14549: APF.business_group_id = c_business_group_id

Line 14557: from BEN_ACTY_RT_PYMT_SCHED_F APF1

14553: and effective_end_date ;
14554: --END TEMPIK
14555: /*TEMPIK
14556: and exists ( select null
14557: from BEN_ACTY_RT_PYMT_SCHED_F APF1
14558: where
14559: APF1.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
14560: APF1.PYMT_SCHED_CD = l_PYMT_SCHED_CD and
14561: APF1.business_group_id = c_business_group_id

Line 14564: from BEN_ACTY_RT_PYMT_SCHED_F APF2

14560: APF1.PYMT_SCHED_CD = l_PYMT_SCHED_CD and
14561: APF1.business_group_id = c_business_group_id
14562: and APF1.effective_start_date <= c_effective_start_date )
14563: and exists ( select null
14564: from BEN_ACTY_RT_PYMT_SCHED_F APF2
14565: where
14566: APF2.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
14567: APF2.PYMT_SCHED_CD = l_PYMT_SCHED_CD and
14568: APF2.business_group_id = c_business_group_id

Line 14713: (p_base_table_name => 'BEN_ACTY_RT_PYMT_SCHED_F',

14709: fetch c_find_APF_in_target into l_new_value ;
14710: if c_find_APF_in_target%found then
14711: --TEMPIK
14712: l_dt_rec_found := dt_api.check_min_max_dates
14713: (p_base_table_name => 'BEN_ACTY_RT_PYMT_SCHED_F',
14714: p_base_key_column => 'ACTY_RT_PYMT_SCHED_ID',
14715: p_base_key_value => l_new_value,
14716: p_from_date => l_min_esd,
14717: p_to_date => l_max_eed );

Line 14776: hr_utility.set_location(' BEN_ACTY_RT_PYMT_SCHED_F CREATE_ACTY_RT_PYMT_SCHED ',20);

14772: --if l_first_rec then
14773: if l_first_rec and not l_update then
14774:
14775: -- Call Create routine.
14776: hr_utility.set_location(' BEN_ACTY_RT_PYMT_SCHED_F CREATE_ACTY_RT_PYMT_SCHED ',20);
14777: BEN_ACTY_RT_PYMT_SCHED_API.CREATE_ACTY_RT_PYMT_SCHED(
14778: --
14779: P_VALIDATE => false
14780: ,P_EFFECTIVE_DATE => l_effective_date

Line 14842: hr_utility.set_location(' BEN_ACTY_RT_PYMT_SCHED_F UPDATE_ACTY_RT_PYMT_SCHED ',30);

14838: else
14839: --
14840: -- Call Update routine for the pk_id created in prev run .
14841: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
14842: hr_utility.set_location(' BEN_ACTY_RT_PYMT_SCHED_F UPDATE_ACTY_RT_PYMT_SCHED ',30);
14843: --UPD START
14844: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
14845: --
14846: if l_update then