APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_CM_DLVRY_MED_TYP

Line 1659: -- and tr.where_clause = l_BEN_CM_DLVRY_MED_TYP

1655: from ben_copy_entity_results cpe,
1656: pqh_table_route tr
1657: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1658: and cpe.table_route_id = tr.table_route_id
1659: -- and tr.where_clause = l_BEN_CM_DLVRY_MED_TYP
1660: and tr.table_alias = l_table_alias
1661: and cpe.number_of_copies = 1 -- ADDITION
1662: -- UPD START
1663: group by cpe.information1,cpe.information2,cpe.information3, cpe.information25, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 1697: from BEN_CM_DLVRY_MED_TYP CMD

1693: c_business_group_id number,
1694: c_new_pk_id number) is
1695: select
1696: CMD.cm_dlvry_med_typ_id new_value
1697: from BEN_CM_DLVRY_MED_TYP CMD
1698: where
1699: CMD.CM_DLVRY_MTHD_TYP_ID = l_CM_DLVRY_MTHD_TYP_ID
1700: and CMD.CM_DLVRY_MED_TYP_CD = l_CM_DLVRY_MED_TYP_CD
1701: and CMD.business_group_id = c_business_group_id

Line 1871: hr_utility.set_location(' BEN_CM_DLVRY_MED_TYP CREATE_COMM_DLVRY_MEDIA ',20);

1867: if l_first_rec and not l_update then
1868: -- UPD END
1869:
1870: -- Call Create routine.
1871: hr_utility.set_location(' BEN_CM_DLVRY_MED_TYP CREATE_COMM_DLVRY_MEDIA ',20);
1872: BEN_COMM_DLVRY_MEDIA_API.CREATE_COMM_DLVRY_MEDIA(
1873: --
1874: P_VALIDATE => false
1875: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 1935: hr_utility.set_location(' BEN_CM_DLVRY_MED_TYP CREATE_COMM_DLVRY_MEDIA ',20);

1931: --
1932: elsif l_update then
1933: --
1934: -- UPD START
1935: hr_utility.set_location(' BEN_CM_DLVRY_MED_TYP CREATE_COMM_DLVRY_MEDIA ',20);
1936: BEN_COMM_DLVRY_MEDIA_API.UPDATE_COMM_DLVRY_MEDIA(
1937: --
1938: P_VALIDATE => false
1939: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)