APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_ACRS_PTIP_CVG_F

Line 26904: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F

26900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26901: pqh_table_route tr
26902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26903: and cpe.table_route_id = tr.table_route_id
26904: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F
26905: and tr.table_alias = l_table_alias
26906: and cpe.number_of_copies = 1 -- ADDITION
26907: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
26908: order by information1, information2; --added for bug: 5151945

Line 26942: from BEN_ACRS_PTIP_CVG_F ACP

26938: c_business_group_id number,
26939: c_new_pk_id number) is
26940: select
26941: ACP.acrs_ptip_cvg_id new_value
26942: from BEN_ACRS_PTIP_CVG_F ACP
26943: where ACP.name = c_ACP_name and
26944: -- nvl(ACP.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
26945: ACP.business_group_id = c_business_group_id
26946: and ACP.acrs_ptip_cvg_id <> c_new_pk_id

Line 26953: from BEN_ACRS_PTIP_CVG_F ACP1

26949: and effective_end_date ;
26950: --END TEMPIK
26951: /*
26952: and exists ( select null
26953: from BEN_ACRS_PTIP_CVG_F ACP1
26954: where ACP1.name = c_ACP_name and
26955: -- nvl(ACP1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
26956: ACP1.business_group_id = c_business_group_id
26957: and ACP1.effective_start_date <= c_effective_start_date )

Line 26959: from BEN_ACRS_PTIP_CVG_F ACP2

26955: -- nvl(ACP1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
26956: ACP1.business_group_id = c_business_group_id
26957: and ACP1.effective_start_date <= c_effective_start_date )
26958: and exists ( select null
26959: from BEN_ACRS_PTIP_CVG_F ACP2
26960: where ACP2.name = c_ACP_name and
26961: -- nvl(ACP2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
26962: ACP2.business_group_id = c_business_group_id
26963: and ACP2.effective_end_date >= c_effective_end_date )

Line 27105: (p_base_table_name => 'BEN_ACRS_PTIP_CVG_F',

27101: if c_find_ACP_in_target%found then
27102: --
27103: --TEMPIK
27104: l_dt_rec_found := dt_api.check_min_max_dates
27105: (p_base_table_name => 'BEN_ACRS_PTIP_CVG_F',
27106: p_base_key_column => 'ACRS_PTIP_CVG_ID',
27107: p_base_key_value => l_new_value,
27108: p_from_date => l_min_esd,
27109: p_to_date => l_max_eed );

Line 27156: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ACRS_PTIP_CVG_F',l_prefix || r_ACP.information170 || l_suffix);

27152: l_first_rec := true ;
27153: --
27154: end if ;
27155: --
27156: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_ACRS_PTIP_CVG_F',l_prefix || r_ACP.information170 || l_suffix);
27157: --
27158:
27159: l_effective_date := r_ACP.information2;
27160: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 27167: hr_utility.set_location(' BEN_ACRS_PTIP_CVG_F CREATE_ACRS_PTIP_CVG ',20);

27163: end if;
27164:
27165: if l_first_rec and not l_update then
27166: -- Call Create routine.
27167: hr_utility.set_location(' BEN_ACRS_PTIP_CVG_F CREATE_ACRS_PTIP_CVG ',20);
27168: BEN_ACRS_PTIP_CVG_API.CREATE_ACRS_PTIP_CVG(
27169: --
27170: P_VALIDATE => false
27171: ,P_EFFECTIVE_DATE => l_effective_date

Line 27235: hr_utility.set_location(' BEN_ACRS_PTIP_CVG_F UPDATE_ACRS_PTIP_CVG ',30);

27231: else
27232: --
27233: -- Call Update routine for the pk_id created in prev run .
27234: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
27235: hr_utility.set_location(' BEN_ACRS_PTIP_CVG_F UPDATE_ACRS_PTIP_CVG ',30);
27236: --UPD START
27237: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
27238: --
27239: if l_update then