APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_SVC_AREA_PSTL_ZIP_RNG_F

Line 712: -- and tr.where_clause = l_BEN_SVC_AREA_PSTL_ZIP_RNG_F

708: from ben_copy_entity_results cpe,
709: pqh_table_route tr
710: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
711: and cpe.table_route_id = tr.table_route_id
712: -- and tr.where_clause = l_BEN_SVC_AREA_PSTL_ZIP_RNG_F
713: and tr.table_alias = l_table_alias
714: and cpe.number_of_copies = 1 --ADDITION
715: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
716: order by information1, information2; --added for bug: 5151945

Line 750: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ

746: c_business_group_id number,
747: c_new_pk_id number) is
748: select
749: SAZ.svc_area_pstl_zip_rng_id new_value
750: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
751: where
752: SAZ.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
753: SAZ.SVC_AREA_ID = l_SVC_AREA_ID and
754: SAZ.business_group_id = c_business_group_id

Line 762: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ1

758: and effective_end_date ;
759: --END TEMPIK
760: /*TEMPIK
761: and exists ( select null
762: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ1
763: where
764: SAZ1.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
765: SAZ1.SVC_AREA_ID = l_SVC_AREA_ID and
766: SAZ1.business_group_id = c_business_group_id

Line 769: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ2

765: SAZ1.SVC_AREA_ID = l_SVC_AREA_ID and
766: SAZ1.business_group_id = c_business_group_id
767: and SAZ1.effective_start_date <= c_effective_start_date )
768: and exists ( select null
769: from BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ2
770: where
771: SAZ2.PSTL_ZIP_RNG_ID = l_PSTL_ZIP_RNG_ID and
772: SAZ2.SVC_AREA_ID = l_SVC_AREA_ID and
773: SAZ2.business_group_id = c_business_group_id

Line 908: (p_base_table_name => 'BEN_SVC_AREA_PSTL_ZIP_RNG_F',

904: if c_find_SAZ_in_target%found then
905: --
906: --TEMPIK
907: l_dt_rec_found := dt_api.check_min_max_dates
908: (p_base_table_name => 'BEN_SVC_AREA_PSTL_ZIP_RNG_F',
909: p_base_key_column => 'SVC_AREA_PSTL_ZIP_RNG_ID',
910: p_base_key_value => l_new_value,
911: p_from_date => l_min_esd,
912: p_to_date => l_max_eed );

Line 968: hr_utility.set_location(' BEN_SVC_AREA_PSTL_ZIP_RNG_F CREATE_SVC_AREA_PSTL_ZIP_RNG ',20);

964: end if;
965:
966: if l_first_rec and not l_update then
967: -- Call Create routine.
968: hr_utility.set_location(' BEN_SVC_AREA_PSTL_ZIP_RNG_F CREATE_SVC_AREA_PSTL_ZIP_RNG ',20);
969: BEN_SVC_AREA_PSTL_ZIP_RNG_API.CREATE_SVC_AREA_PSTL_ZIP_RNG(
970: --
971: P_VALIDATE => false
972: ,P_EFFECTIVE_DATE => l_effective_date

Line 1033: hr_utility.set_location(' BEN_SVC_AREA_PSTL_ZIP_RNG_F UPDATE_SVC_AREA_PSTL_ZIP_RNG ',30);

1029: else
1030: --
1031: -- Call Update routine for the pk_id created in prev run .
1032: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1033: hr_utility.set_location(' BEN_SVC_AREA_PSTL_ZIP_RNG_F UPDATE_SVC_AREA_PSTL_ZIP_RNG ',30);
1034: --UPD START
1035: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
1036: --
1037: if l_update then