APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_LGL_ENTY_RT_F

Line 8798: -- and tr.where_clause = l_BEN_LGL_ENTY_RT_F

8794: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8795: pqh_table_route tr
8796: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8797: and cpe.table_route_id = tr.table_route_id
8798: -- and tr.where_clause = l_BEN_LGL_ENTY_RT_F
8799: and tr.table_alias = l_table_alias
8800: and cpe.number_of_copies = 1 -- ADDITION
8801: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8802: order by information1, information2; --added for bug: 5151945

Line 8836: from BEN_LGL_ENTY_RT_F LER1

8832: c_business_group_id number,
8833: c_new_pk_id number) is
8834: select
8835: LER1.lgl_enty_rt_id new_value
8836: from BEN_LGL_ENTY_RT_F LER1
8837: where
8838: LER1.ORGANIZATION_ID = l_ORGANIZATION_ID and
8839: LER1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8840: LER1.business_group_id = c_business_group_id

Line 8848: from BEN_LGL_ENTY_RT_F LER11

8844: and effective_end_date ;
8845: --END TEMPIK
8846: /*TEMPIK
8847: and exists ( select null
8848: from BEN_LGL_ENTY_RT_F LER11
8849: where
8850: LER11.ORGANIZATION_ID = l_ORGANIZATION_ID and
8851: LER11.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8852: LER11.business_group_id = c_business_group_id

Line 8855: from BEN_LGL_ENTY_RT_F LER12

8851: LER11.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8852: LER11.business_group_id = c_business_group_id
8853: and LER11.effective_start_date <= c_effective_start_date )
8854: and exists ( select null
8855: from BEN_LGL_ENTY_RT_F LER12
8856: where
8857: LER12.ORGANIZATION_ID = l_ORGANIZATION_ID and
8858: LER12.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8859: LER12.business_group_id = c_business_group_id

Line 9008: (p_base_table_name => 'BEN_LGL_ENTY_RT_F',

9004: if c_find_LER1_in_target%found then
9005: --
9006: --TEMPIK
9007: l_dt_rec_found := dt_api.check_min_max_dates
9008: (p_base_table_name => 'BEN_LGL_ENTY_RT_F',
9009: p_base_key_column => 'LGL_ENTY_RT_ID',
9010: p_base_key_value => l_new_value,
9011: p_from_date => l_min_esd,
9012: p_to_date => l_max_eed );

Line 9066: hr_utility.set_location(' BEN_LGL_ENTY_RT_F CREATE_LEGAL_ENTITY_RATE ',20);

9062: end if;
9063:
9064: if l_first_rec and not l_update then
9065: -- Call Create routine.
9066: hr_utility.set_location(' BEN_LGL_ENTY_RT_F CREATE_LEGAL_ENTITY_RATE ',20);
9067: BEN_LEGAL_ENTITY_RATE_API.CREATE_LEGAL_ENTITY_RATE(
9068: --
9069: P_VALIDATE => false
9070: ,P_EFFECTIVE_DATE => l_effective_date

Line 9158: hr_utility.set_location(' BEN_LGL_ENTY_RT_F UPDATE_LEGAL_ENTITY_RATE ',30);

9154: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
9155: --
9156: IF l_update OR l_dml_operation <> 'UPDATE' THEN
9157: --UPD END
9158: hr_utility.set_location(' BEN_LGL_ENTY_RT_F UPDATE_LEGAL_ENTITY_RATE ',30);
9159: BEN_LEGAL_ENTITY_RATE_API.UPDATE_LEGAL_ENTITY_RATE(
9160: --
9161: P_VALIDATE => false
9162: ,P_EFFECTIVE_DATE => l_effective_date