APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 2251: -- and tr.where_clause = l_BEN_ELIG_BRGNG_UNIT_PRTE_F

2247: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2248: pqh_table_route tr
2249: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2250: and cpe.table_route_id = tr.table_route_id
2251: -- and tr.where_clause = l_BEN_ELIG_BRGNG_UNIT_PRTE_F
2252: and tr.table_alias = l_table_alias
2253: and cpe.number_of_copies = 1 -- ADDITION
2254: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2255: order by information1, information2; --added for bug: 5151945

Line 2289: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU

2285: c_business_group_id number,
2286: c_new_pk_id number) is
2287: select
2288: EBU.elig_brgng_unit_prte_id new_value
2289: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU
2290: where
2291: EBU.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
2292: EBU.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and -- IK
2293: EBU.business_group_id = c_business_group_id

Line 2301: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU1

2297: and effective_end_date ;
2298: --END TEMPIK
2299: /*TEMPIK
2300: and exists ( select null
2301: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU1
2302: where
2303: EBU1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
2304: EBU1.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and -- IK
2305: EBU1.business_group_id = c_business_group_id

Line 2308: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU2

2304: EBU1.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and -- IK
2305: EBU1.business_group_id = c_business_group_id
2306: and EBU1.effective_start_date <= c_effective_start_date )
2307: and exists ( select null
2308: from BEN_ELIG_BRGNG_UNIT_PRTE_F EBU2
2309: where
2310: EBU2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
2311: EBU2.BRGNG_UNIT_CD = l_BRGNG_UNIT_CD and -- IK
2312: EBU2.business_group_id = c_business_group_id

Line 2464: (p_base_table_name => 'BEN_ELIG_BRGNG_UNIT_PRTE_F',

2460: if c_find_EBU_in_target%found then
2461: --
2462: --TEMPIK
2463: l_dt_rec_found := dt_api.check_min_max_dates
2464: (p_base_table_name => 'BEN_ELIG_BRGNG_UNIT_PRTE_F',
2465: p_base_key_column => 'ELIG_BRGNG_UNIT_PRTE_ID',
2466: p_base_key_value => l_new_value,
2467: p_from_date => l_min_esd,
2468: p_to_date => l_max_eed );

Line 2524: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);

2520: end if;
2521:
2522: if l_first_rec and not l_update then
2523: -- Call Create routine.
2524: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F CREATE_ELIG_BRGNG_UNIT_PRTE ',20);
2525: BEN_ELIG_BRGNG_UNIT_PRTE_API.CREATE_ELIG_BRGNG_UNIT_PRTE(
2526: --
2527: P_VALIDATE => false
2528: ,P_EFFECTIVE_DATE => l_effective_date

Line 2597: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F UPDATE_ELIG_BRGNG_UNIT_PRTE ',30);

2593: else
2594: --
2595: -- Call Update routine for the pk_id created in prev run .
2596: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2597: hr_utility.set_location(' BEN_ELIG_BRGNG_UNIT_PRTE_F UPDATE_ELIG_BRGNG_UNIT_PRTE ',30);
2598: --UPD START
2599: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
2600: --
2601: if l_update then