APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_PGM_ENRT_F

Line 20199: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F

20195: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20196: pqh_table_route tr
20197: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20198: and cpe.table_route_id = tr.table_route_id
20199: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F
20200: and tr.table_alias = l_table_alias
20201: and cpe.number_of_copies = 1 -- ADDITION
20202: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
20203: order by information1, information2; --added for bug: 5151945

Line 20237: from BEN_LER_CHG_PGM_ENRT_F LGE

20233: c_business_group_id number,
20234: c_new_pk_id number) is
20235: select
20236: LGE.ler_chg_pgm_enrt_id new_value
20237: from BEN_LER_CHG_PGM_ENRT_F LGE
20238: where
20239: LGE.LER_ID = l_LER_ID and
20240: LGE.PGM_ID = l_PGM_ID and
20241: LGE.business_group_id = c_business_group_id

Line 20249: from BEN_LER_CHG_PGM_ENRT_F LGE1

20245: and effective_end_date ;
20246: --END TEMPIK
20247: /*TEMPIK
20248: and exists ( select null
20249: from BEN_LER_CHG_PGM_ENRT_F LGE1
20250: where
20251: LGE1.LER_ID = l_LER_ID and
20252: LGE1.PGM_ID = l_PGM_ID and
20253: LGE1.business_group_id = c_business_group_id

Line 20256: from BEN_LER_CHG_PGM_ENRT_F LGE2

20252: LGE1.PGM_ID = l_PGM_ID and
20253: LGE1.business_group_id = c_business_group_id
20254: and LGE1.effective_start_date <= c_effective_start_date )
20255: and exists ( select null
20256: from BEN_LER_CHG_PGM_ENRT_F LGE2
20257: where
20258: LGE2.LER_ID = l_LER_ID and
20259: LGE2.PGM_ID = l_PGM_ID and
20260: LGE2.business_group_id = c_business_group_id

Line 20404: (p_base_table_name => 'BEN_LER_CHG_PGM_ENRT_F',

20400: fetch c_find_LGE_in_target into l_new_value ;
20401: if c_find_LGE_in_target%found then
20402: --TEMPIK
20403: l_dt_rec_found := dt_api.check_min_max_dates
20404: (p_base_table_name => 'BEN_LER_CHG_PGM_ENRT_F',
20405: p_base_key_column => 'LER_CHG_PGM_ENRT_ID',
20406: p_base_key_value => l_new_value,
20407: p_from_date => l_min_esd,
20408: p_to_date => l_max_eed );

Line 20464: hr_utility.set_location(' BEN_LER_CHG_PGM_ENRT_F CREATE_LER_CHG_PGM_ENRT ',20);

20460: end if;
20461:
20462: if l_first_rec and not l_update then
20463: -- Call Create routine.
20464: hr_utility.set_location(' BEN_LER_CHG_PGM_ENRT_F CREATE_LER_CHG_PGM_ENRT ',20);
20465: BEN_LER_CHG_PGM_ENRT_API.CREATE_LER_CHG_PGM_ENRT(
20466: --
20467: P_VALIDATE => false
20468: ,P_EFFECTIVE_DATE => l_effective_date

Line 20537: hr_utility.set_location(' BEN_LER_CHG_PGM_ENRT_F UPDATE_LER_CHG_PGM_ENRT ',30);

20533: else
20534: --
20535: -- Call Update routine for the pk_id created in prev run .
20536: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
20537: hr_utility.set_location(' BEN_LER_CHG_PGM_ENRT_F UPDATE_LER_CHG_PGM_ENRT ',30);
20538: --UPD START
20539: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
20540: --
20541: if l_update then