APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_LGL_ENTY_PRTE_F

Line 8867: -- and tr.where_clause = l_BEN_ELIG_LGL_ENTY_PRTE_F

8863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8864: pqh_table_route tr
8865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8866: and cpe.table_route_id = tr.table_route_id
8867: -- and tr.where_clause = l_BEN_ELIG_LGL_ENTY_PRTE_F
8868: and tr.table_alias = l_table_alias
8869: and cpe.number_of_copies = 1 -- ADDITION
8870: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8871: order by information1, information2; --added for bug: 5151945

Line 8905: from BEN_ELIG_LGL_ENTY_PRTE_F ELN

8901: c_business_group_id number,
8902: c_new_pk_id number) is
8903: select
8904: ELN.elig_lgl_enty_prte_id new_value
8905: from BEN_ELIG_LGL_ENTY_PRTE_F ELN
8906: where
8907: ELN.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
8908: ELN.ORGANIZATION_ID = l_ORGANIZATION_ID and
8909: ELN.business_group_id = c_business_group_id

Line 8916: from BEN_ELIG_LGL_ENTY_PRTE_F ELN1

8912: and effective_end_date ;
8913: --END TEMPIK
8914: /*TEMPIK
8915: and exists ( select null
8916: from BEN_ELIG_LGL_ENTY_PRTE_F ELN1
8917: where
8918: ELN1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
8919: ELN1.ORGANIZATION_ID = l_ORGANIZATION_ID and
8920: ELN1.business_group_id = c_business_group_id

Line 8923: from BEN_ELIG_LGL_ENTY_PRTE_F ELN2

8919: ELN1.ORGANIZATION_ID = l_ORGANIZATION_ID and
8920: ELN1.business_group_id = c_business_group_id
8921: and ELN1.effective_start_date <= c_effective_start_date )
8922: and exists ( select null
8923: from BEN_ELIG_LGL_ENTY_PRTE_F ELN2
8924: where
8925: ELN2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
8926: ELN2.ORGANIZATION_ID = l_ORGANIZATION_ID and
8927: ELN2.business_group_id = c_business_group_id

Line 9099: (p_base_table_name => 'BEN_ELIG_LGL_ENTY_PRTE_F',

9095: if c_find_ELN_in_target%found then
9096: --
9097: --TEMPIK
9098: l_dt_rec_found := dt_api.check_min_max_dates
9099: (p_base_table_name => 'BEN_ELIG_LGL_ENTY_PRTE_F',
9100: p_base_key_column => 'ELIG_LGL_ENTY_PRTE_ID',
9101: p_base_key_value => l_new_value,
9102: p_from_date => l_min_esd,
9103: p_to_date => l_max_eed );

Line 9161: hr_utility.set_location(' BEN_ELIG_LGL_ENTY_PRTE_F CREATE_ELIG_LGL_ENTY_PRTE ',20);

9157: end if;
9158:
9159: if l_first_rec and not l_update then
9160: -- Call Create routine.
9161: hr_utility.set_location(' BEN_ELIG_LGL_ENTY_PRTE_F CREATE_ELIG_LGL_ENTY_PRTE ',20);
9162: BEN_ELIG_LGL_ENTY_PRTE_API.CREATE_ELIG_LGL_ENTY_PRTE(
9163: --
9164: P_VALIDATE => false
9165: ,P_EFFECTIVE_DATE => l_effective_date

Line 9234: hr_utility.set_location(' BEN_ELIG_LGL_ENTY_PRTE_F UPDATE_ELIG_LGL_ENTY_PRTE ',30);

9230: else
9231: --
9232: -- Call Update routine for the pk_id created in prev run .
9233: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
9234: hr_utility.set_location(' BEN_ELIG_LGL_ENTY_PRTE_F UPDATE_ELIG_LGL_ENTY_PRTE ',30);
9235: --UPD START
9236: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
9237: --
9238: if l_update then