APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_SUPPL_ROLE_PRTE_F

Line 20060: -- and tr.where_clause = l_BEN_ELIG_SUPPL_ROLE_PRTE_F

20056: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20057: pqh_table_route tr
20058: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20059: and cpe.table_route_id = tr.table_route_id
20060: -- and tr.where_clause = l_BEN_ELIG_SUPPL_ROLE_PRTE_F
20061: and tr.table_alias = l_table_alias
20062: and cpe.number_of_copies = 1 -- ADDITION
20063: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
20064: order by information1, information2; --added for bug: 5151945

Line 20098: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST

20094: c_business_group_id number,
20095: c_new_pk_id number) is
20096: select
20097: EST.elig_suppl_role_prte_id new_value
20098: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST
20099: where
20100: nvl(EST.ELIGY_PRFL_ID,-999) = l_ELIGY_PRFL_ID and
20101: nvl(EST.JOB_GROUP_ID,-999) = l_JOB_GROUP_ID and
20102: nvl(EST.JOB_ID,-999) = l_JOB_ID and

Line 20110: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST1

20106: and effective_end_date ;
20107: --END TEMPIK
20108: /*TEMPIK
20109: and exists ( select null
20110: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST1
20111: where
20112: EST1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
20113: EST1.JOB_GROUP_ID = l_JOB_GROUP_ID and
20114: EST1.JOB_ID = l_JOB_ID and

Line 20118: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST2

20114: EST1.JOB_ID = l_JOB_ID and
20115: EST1.business_group_id = c_business_group_id
20116: and EST1.effective_start_date <= c_effective_start_date )
20117: and exists ( select null
20118: from BEN_ELIG_SUPPL_ROLE_PRTE_F EST2
20119: where
20120: EST2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
20121: EST2.JOB_GROUP_ID = l_JOB_GROUP_ID and
20122: EST2.JOB_ID = l_JOB_ID and

Line 20301: (p_base_table_name => 'BEN_ELIG_SUPPL_ROLE_PRTE_F',

20297: if c_find_EST_in_target%found then
20298: --
20299: --TEMPIK
20300: l_dt_rec_found := dt_api.check_min_max_dates
20301: (p_base_table_name => 'BEN_ELIG_SUPPL_ROLE_PRTE_F',
20302: p_base_key_column => 'ELIG_SUPPL_ROLE_PRTE_ID',
20303: p_base_key_value => l_new_value,
20304: p_from_date => l_min_esd,
20305: p_to_date => l_max_eed );

Line 20361: hr_utility.set_location(' BEN_ELIG_SUPPL_ROLE_PRTE_F CREATE_ELIG_SUPPL_ROLE_PRTE ',20);

20357: end if;
20358:
20359: if l_first_rec and not l_update then
20360: -- Call Create routine.
20361: hr_utility.set_location(' BEN_ELIG_SUPPL_ROLE_PRTE_F CREATE_ELIG_SUPPL_ROLE_PRTE ',20);
20362: BEN_ELIG_SUPPL_ROLE_PRTE_API.CREATE_ELIG_SUPPL_ROLE_PRTE(
20363: --
20364: P_VALIDATE => false
20365: ,P_EFFECTIVE_DATE => l_effective_date

Line 20435: hr_utility.set_location(' BEN_ELIG_SUPPL_ROLE_PRTE_F UPDATE_ELIG_SUPPL_ROLE_PRTE ',30);

20431: else
20432: --
20433: -- Call Update routine for the pk_id created in prev run .
20434: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
20435: hr_utility.set_location(' BEN_ELIG_SUPPL_ROLE_PRTE_F UPDATE_ELIG_SUPPL_ROLE_PRTE ',30);
20436: --UPD START
20437: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
20438: --
20439: if l_update then