APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_PYMT_SCHED_PY_FREQ

Line 14138: l_PY_FREQ_CD ben_pymt_sched_py_freq.py_freq_cd%type;

14134: ,p_prefix_suffix_cd in varchar2 default null
14135: ) is
14136: --
14137: l_ACTY_RT_PYMT_SCHED_ID number;
14138: l_PY_FREQ_CD ben_pymt_sched_py_freq.py_freq_cd%type;
14139: cursor c_unique_PSQ(l_table_alias varchar2) is
14140: select distinct cpe.information1,
14141: cpe.information2,
14142: cpe.information3,

Line 14150: -- and tr.where_clause = l_BEN_PYMT_SCHED_PY_FREQ

14146: from ben_copy_entity_results cpe,
14147: pqh_table_route tr
14148: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14149: and cpe.table_route_id = tr.table_route_id
14150: -- and tr.where_clause = l_BEN_PYMT_SCHED_PY_FREQ
14151: and tr.table_alias = l_table_alias
14152: and cpe.number_of_copies = 1
14153: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14154: order by information1, information2; --added for bug: 5151945

Line 14186: from BEN_PYMT_SCHED_PY_FREQ PSQ

14182: c_business_group_id number,
14183: c_new_pk_id number) is
14184: select
14185: PSQ.pymt_sched_py_freq_id new_value
14186: from BEN_PYMT_SCHED_PY_FREQ PSQ
14187: where
14188: PSQ.business_group_id = c_business_group_id and
14189: PSQ.PY_FREQ_CD = l_PY_FREQ_CD and
14190: PSQ.ACTY_RT_PYMT_SCHED_ID = l_ACTY_RT_PYMT_SCHED_ID

Line 14356: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ CREATE_PYMT_SCHED_PY_FREQ ',20);

14352: --
14353: --if l_first_rec then
14354: if l_first_rec and not l_update then
14355: -- Call Create routine.
14356: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ CREATE_PYMT_SCHED_PY_FREQ ',20);
14357: BEN_PYMT_SCHED_PY_FREQ_API.CREATE_PYMT_SCHED_PY_FREQ(
14358: --
14359: P_VALIDATE => false
14360: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 14357: BEN_PYMT_SCHED_PY_FREQ_API.CREATE_PYMT_SCHED_PY_FREQ(

14353: --if l_first_rec then
14354: if l_first_rec and not l_update then
14355: -- Call Create routine.
14356: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ CREATE_PYMT_SCHED_PY_FREQ ',20);
14357: BEN_PYMT_SCHED_PY_FREQ_API.CREATE_PYMT_SCHED_PY_FREQ(
14358: --
14359: P_VALIDATE => false
14360: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
14361: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 14417: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ UPDATE_PYMT_SCHED_PY_FREQ ',20);

14413: --
14414: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
14415: elsif l_update then
14416: --
14417: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ UPDATE_PYMT_SCHED_PY_FREQ ',20);
14418: BEN_PYMT_SCHED_PY_FREQ_API.UPDATE_PYMT_SCHED_PY_FREQ(
14419: --
14420: P_VALIDATE => false
14421: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 14418: BEN_PYMT_SCHED_PY_FREQ_API.UPDATE_PYMT_SCHED_PY_FREQ(

14414: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
14415: elsif l_update then
14416: --
14417: hr_utility.set_location(' BEN_PYMT_SCHED_PY_FREQ UPDATE_PYMT_SCHED_PY_FREQ ',20);
14418: BEN_PYMT_SCHED_PY_FREQ_API.UPDATE_PYMT_SCHED_PY_FREQ(
14419: --
14420: P_VALIDATE => false
14421: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
14422: ,P_BUSINESS_GROUP_ID => p_target_business_group_id