APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 10232: from BEN_LER_PER_INFO_CS_LER_F LPL

10228: c_business_group_id number,
10229: c_new_pk_id number) is
10230: select
10231: LPL.ler_per_info_cs_ler_id new_value
10232: from BEN_LER_PER_INFO_CS_LER_F LPL
10233: where
10234: LPL.LER_ID = l_LER_ID and
10235: LPL.PER_INFO_CHG_CS_LER_ID = l_PER_INFO_CHG_CS_LER_ID and
10236: LPL.business_group_id = c_business_group_id

Line 10244: from BEN_LER_PER_INFO_CS_LER_F LPL1

10240: and effective_end_date ;
10241: --END TEMPIK
10242: /*TEMPIK
10243: and exists ( select null
10244: from BEN_LER_PER_INFO_CS_LER_F LPL1
10245: where
10246: LPL1.LER_ID = l_LER_ID and
10247: LPL1.PER_INFO_CHG_CS_LER_ID = l_PER_INFO_CHG_CS_LER_ID and
10248: LPL1.business_group_id = c_business_group_id

Line 10251: from BEN_LER_PER_INFO_CS_LER_F LPL2

10247: LPL1.PER_INFO_CHG_CS_LER_ID = l_PER_INFO_CHG_CS_LER_ID and
10248: LPL1.business_group_id = c_business_group_id
10249: and LPL1.effective_start_date <= c_effective_start_date )
10250: and exists ( select null
10251: from BEN_LER_PER_INFO_CS_LER_F LPL2
10252: where
10253: LPL2.LER_ID = l_LER_ID and
10254: LPL2.PER_INFO_CHG_CS_LER_ID = l_PER_INFO_CHG_CS_LER_ID and
10255: LPL2.business_group_id = c_business_group_id

Line 10401: (p_base_table_name => 'BEN_LER_PER_INFO_CS_LER_F',

10397: if c_find_LPL_in_target%found then
10398: --
10399: --TEMPIK
10400: l_dt_rec_found := dt_api.check_min_max_dates
10401: (p_base_table_name => 'BEN_LER_PER_INFO_CS_LER_F',
10402: p_base_key_column => 'LER_PER_INFO_CS_LER_ID',
10403: p_base_key_value => l_new_value,
10404: p_from_date => l_min_esd,
10405: p_to_date => l_max_eed );

Line 10459: hr_utility.set_location(' BEN_LER_PER_INFO_CS_LER_F CREATE_LER_PER_INFO_CS_LER ',20);

10455: end if;
10456: --
10457: if l_first_rec and not l_update then
10458: -- Call Create routine.
10459: hr_utility.set_location(' BEN_LER_PER_INFO_CS_LER_F CREATE_LER_PER_INFO_CS_LER ',20);
10460: BEN_LER_PER_INFO_CS_LER_API.CREATE_LER_PER_INFO_CS_LER(
10461: --
10462: P_VALIDATE => false
10463: ,P_EFFECTIVE_DATE => l_effective_date

Line 10550: hr_utility.set_location(' BEN_LER_PER_INFO_CS_LER_F UPDATE_LER_PER_INFO_CS_LER ',30);

10546: IF l_update OR l_dml_operation <> 'UPDATE' THEN
10547: --UPD END
10548: -- Call Update routine for the pk_id created in prev run .
10549: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
10550: hr_utility.set_location(' BEN_LER_PER_INFO_CS_LER_F UPDATE_LER_PER_INFO_CS_LER ',30);
10551: BEN_LER_PER_INFO_CS_LER_API.UPDATE_LER_PER_INFO_CS_LER(
10552: --
10553: P_VALIDATE => false
10554: ,P_EFFECTIVE_DATE => l_effective_date