APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_CM_DLVRY_MTHD_TYP

Line 1289: -- and tr.where_clause = l_BEN_CM_DLVRY_MTHD_TYP

1285: from ben_copy_entity_results cpe,
1286: pqh_table_route tr
1287: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1288: and cpe.table_route_id = tr.table_route_id
1289: -- and tr.where_clause = l_BEN_CM_DLVRY_MTHD_TYP
1290: and tr.table_alias = l_table_alias
1291: and cpe.number_of_copies = 1 -- ADDITION
1292: -- UPD START
1293: group by cpe.information1,cpe.information2,cpe.information3, cpe.information25, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 1327: from BEN_CM_DLVRY_MTHD_TYP CMT

1323: c_business_group_id number,
1324: c_new_pk_id number) is
1325: select
1326: CMT.cm_dlvry_mthd_typ_id new_value
1327: from BEN_CM_DLVRY_MTHD_TYP CMT
1328: where
1329: CMT.CM_TYP_ID = l_CM_TYP_ID and
1330: CMT.CM_DLVRY_MTHD_TYP_CD = l_CM_DLVRY_MTHD_TYP_CD and
1331: CMT.business_group_id = c_business_group_id

Line 1506: hr_utility.set_location(' BEN_CM_DLVRY_MTHD_TYP CREATE_COMM_DLVRY_MTHDS ',20);

1502: --if l_first_rec then
1503: -- UPD END
1504:
1505: -- Call Create routine.
1506: hr_utility.set_location(' BEN_CM_DLVRY_MTHD_TYP CREATE_COMM_DLVRY_MTHDS ',20);
1507: BEN_COMM_DLVRY_MTHDS_API.CREATE_COMM_DLVRY_MTHDS(
1508: --
1509: P_VALIDATE => false
1510: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)