APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_CM_TYP_USG_F

Line 270: -- and tr.where_clause = l_BEN_CM_TYP_USG_F

266: from ben_copy_entity_results cpe,
267: pqh_table_route tr
268: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
269: and cpe.table_route_id = tr.table_route_id
270: -- and tr.where_clause = l_BEN_CM_TYP_USG_F
271: and tr.table_alias = l_table_alias
272: and cpe.number_of_copies = 1 -- ADDITION
273: -- UPD START
274: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 310: from BEN_CM_TYP_USG_F CTU

306: c_business_group_id number,
307: c_new_pk_id number) is
308: select
309: CTU.cm_typ_usg_id new_value
310: from BEN_CM_TYP_USG_F CTU
311: where
312: nvl(CTU.ACTN_TYP_ID,-999) = nvl(l_ACTN_TYP_ID,-999) and
313: nvl(CTU.CM_TYP_ID,-999) = nvl(l_CM_TYP_ID,-999) and
314: nvl(CTU.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and

Line 327: from BEN_CM_TYP_USG_F CTU1

323: and effective_end_date ;
324: --END TEMPIK
325: --TEMPIK
326: /* and exists ( select null
327: from BEN_CM_TYP_USG_F CTU1
328: where
329: nvl(CTU1.ACTN_TYP_ID,-999) = nvl(l_ACTN_TYP_ID,-999) and
330: nvl(CTU1.CM_TYP_ID,-999) = nvl(l_CM_TYP_ID,-999) and
331: nvl(CTU1.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and

Line 339: from BEN_CM_TYP_USG_F CTU2

335: nvl(CTU1.PL_TYP_ID,-999) = nvl(l_PL_TYP_ID,-999) and
336: CTU1.business_group_id = c_business_group_id
337: and CTU1.effective_start_date <= c_effective_start_date )
338: and exists ( select null
339: from BEN_CM_TYP_USG_F CTU2
340: where
341: nvl(CTU2.ACTN_TYP_ID,-999) = nvl(l_ACTN_TYP_ID,-999) and
342: nvl(CTU2.CM_TYP_ID,-999) = nvl(l_CM_TYP_ID,-999) and
343: nvl(CTU2.ENRT_PERD_ID,-999) = nvl(l_ENRT_PERD_ID,-999) and

Line 507: (p_base_table_name => 'BEN_CM_TYP_USG_F',

503: if c_find_CTU_in_target%found then
504: --
505: --TEMPIK
506: l_dt_rec_found := dt_api.check_min_max_dates
507: (p_base_table_name => 'BEN_CM_TYP_USG_F',
508: p_base_key_column => 'CM_TYP_USG_ID',
509: p_base_key_value => l_new_value,
510: p_from_date => l_min_esd,
511: p_to_date => l_max_eed );

Line 574: hr_utility.set_location(' BEN_CM_TYP_USG_F CREATE_CM_TYP_USG ',20);

570: if l_first_rec and not l_update then
571: -- UPD END
572:
573: -- Call Create routine.
574: hr_utility.set_location(' BEN_CM_TYP_USG_F CREATE_CM_TYP_USG ',20);
575: BEN_CM_TYP_USG_API.CREATE_CM_TYP_USG(
576: --
577: P_VALIDATE => false
578: ,P_EFFECTIVE_DATE => l_effective_date

Line 647: hr_utility.set_location(' BEN_CM_TYP_USG_F UPDATE_CM_TYP_USG ',30);

643: else
644: --
645: -- Call Update routine for the pk_id created in prev run .
646: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
647: hr_utility.set_location(' BEN_CM_TYP_USG_F UPDATE_CM_TYP_USG ',30);
648:
649: --UPD START
650: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
651: --