APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 20687: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F

20683: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20684: pqh_table_route tr
20685: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20686: and cpe.table_route_id = tr.table_route_id
20687: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20688: and tr.table_alias = l_table_alias
20689: and cpe.number_of_copies = 1 -- ADDITION
20690: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
20691: order by information1, information2; --added for bug: 5151945

Line 20725: from BEN_LER_CHG_DPNT_CVG_F LDC

20721: c_business_group_id number,
20722: c_new_pk_id number) is
20723: select
20724: LDC.ler_chg_dpnt_cvg_id new_value
20725: from BEN_LER_CHG_DPNT_CVG_F LDC
20726: where
20727: LDC.LER_ID = l_LER_ID and
20728: nvl(LDC.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20729: nvl(LDC.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20739: from BEN_LER_CHG_DPNT_CVG_F LDC1

20735: and effective_end_date ;
20736: --END TEMPIK
20737: /*TEMPIK
20738: and exists ( select null
20739: from BEN_LER_CHG_DPNT_CVG_F LDC1
20740: where
20741: LDC1.LER_ID = l_LER_ID and
20742: nvl(LDC1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20743: nvl(LDC1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20748: from BEN_LER_CHG_DPNT_CVG_F LDC2

20744: nvl(LDC1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999) and
20745: LDC1.business_group_id = c_business_group_id
20746: and LDC1.effective_start_date <= c_effective_start_date )
20747: and exists ( select null
20748: from BEN_LER_CHG_DPNT_CVG_F LDC2
20749: where
20750: LDC2.LER_ID = l_LER_ID and
20751: nvl(LDC2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
20752: nvl(LDC2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 20902: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',

20898: if c_find_LDC_in_target%found then
20899: --
20900: --TEMPIK
20901: l_dt_rec_found := dt_api.check_min_max_dates
20902: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',
20903: p_base_key_column => 'LER_CHG_DPNT_CVG_ID',
20904: p_base_key_value => l_new_value,
20905: p_from_date => l_min_esd,
20906: p_to_date => l_max_eed );

Line 20961: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F CREATE_LER_CHG_DEPENDENT_CVG ',20);

20957: end if;
20958:
20959: if l_first_rec and not l_update then
20960: -- Call Create routine.
20961: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F CREATE_LER_CHG_DEPENDENT_CVG ',20);
20962: BEN_LER_CHG_DEPENDENT_CVG_API.CREATE_LER_CHG_DEPENDENT_CVG(
20963: --
20964: P_VALIDATE => false
20965: ,P_EFFECTIVE_DATE => l_effective_date

Line 21037: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F UPDATE_LER_CHG_DEPENDENT_CVG ',30);

21033: else
21034: --
21035: -- Call Update routine for the pk_id created in prev run .
21036: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21037: hr_utility.set_location(' BEN_LER_CHG_DPNT_CVG_F UPDATE_LER_CHG_DEPENDENT_CVG ',30);
21038: --UPD START
21039: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21040: --
21041: if l_update then