APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_ACTN_TYP

Line 1690: -- and tr.where_clause = l_BEN_ACTN_TYP

1686: from ben_copy_entity_results cpe,
1687: pqh_table_route tr
1688: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1689: and cpe.table_route_id = tr.table_route_id
1690: -- and tr.where_clause = l_BEN_ACTN_TYP
1691: and tr.table_alias = l_table_alias
1692: group by cpe.information1,cpe.information2,cpe.information3,
1693: cpe.information170, cpe.table_route_id
1694: order by information1, information2; --added for bug: 5151945

Line 1726: from BEN_ACTN_TYP EAT

1722: c_business_group_id number,
1723: c_new_pk_id number) is
1724: select
1725: EAT.actn_typ_id new_value
1726: from BEN_ACTN_TYP EAT
1727: where
1728: EAT.name = c_EAT_name and
1729: EAT.business_group_id = c_business_group_id
1730: and EAT.actn_typ_id <> c_new_pk_id

Line 1840: hr_utility.set_location(' BEN_ACTN_TYP CREATE_ACTION_TYPE ',20);

1836: end if ;
1837: --
1838: if l_first_rec then
1839: -- Call Create routine.
1840: hr_utility.set_location(' BEN_ACTN_TYP CREATE_ACTION_TYPE ',20);
1841: BEN_ACTION_TYPE_API.CREATE_ACTION_TYPE(
1842: --
1843: P_VALIDATE => false
1844: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)