APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 11422: -- and tr.where_clause = l_BEN_ELIG_NO_OTHR_CVG_PRTE_F

11418: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11419: pqh_table_route tr
11420: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11421: and cpe.table_route_id = tr.table_route_id
11422: -- and tr.where_clause = l_BEN_ELIG_NO_OTHR_CVG_PRTE_F
11423: and tr.table_alias = l_table_alias
11424: and cpe.number_of_copies = 1 -- ADDITION
11425: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11426: order by information1, information2; --added for bug: 5151945

Line 11460: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO

11456: c_business_group_id number,
11457: c_new_pk_id number) is
11458: select
11459: ENO.elig_no_othr_cvg_prte_id new_value
11460: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO
11461: where
11462: ENO.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
11463: ENO.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
11464: ENO.business_group_id = c_business_group_id

Line 11471: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO1

11467: and effective_end_date ;
11468: --END TEMPIK
11469: /*TEMPIK
11470: and exists ( select null
11471: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO1
11472: where
11473: ENO1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
11474: ENO1.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
11475: ENO1.business_group_id = c_business_group_id

Line 11478: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO2

11474: ENO1.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
11475: ENO1.business_group_id = c_business_group_id
11476: and ENO1.effective_start_date <= c_effective_start_date )
11477: and exists ( select null
11478: from BEN_ELIG_NO_OTHR_CVG_PRTE_F ENO2
11479: where
11480: ENO2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
11481: ENO2.COORD_BEN_NO_CVG_FLAG = l_COORD_BEN_NO_CVG_FLAG and
11482: ENO2.business_group_id = c_business_group_id

Line 11634: (p_base_table_name => 'BEN_ELIG_NO_OTHR_CVG_PRTE_F',

11630: if c_find_ENO_in_target%found then
11631: --
11632: --TEMPIK
11633: l_dt_rec_found := dt_api.check_min_max_dates
11634: (p_base_table_name => 'BEN_ELIG_NO_OTHR_CVG_PRTE_F',
11635: p_base_key_column => 'ELIG_NO_OTHR_CVG_PRTE_ID',
11636: p_base_key_value => l_new_value,
11637: p_from_date => l_min_esd,
11638: p_to_date => l_max_eed );

Line 11694: hr_utility.set_location(' BEN_ELIG_NO_OTHR_CVG_PRTE_F CREATE_ELIG_NO_OTHR_CVG_PRTE ',20);

11690: end if;
11691:
11692: if l_first_rec and not l_update then
11693: -- Call Create routine.
11694: hr_utility.set_location(' BEN_ELIG_NO_OTHR_CVG_PRTE_F CREATE_ELIG_NO_OTHR_CVG_PRTE ',20);
11695: BEN_ELIG_NO_OTHR_CVG_PRTE_API.CREATE_ELIG_NO_OTHR_CVG_PRTE(
11696: --
11697: P_VALIDATE => false
11698: ,P_EFFECTIVE_DATE => l_effective_date

Line 11763: hr_utility.set_location(' BEN_ELIG_NO_OTHR_CVG_PRTE_F UPDATE_ELIG_NO_OTHR_CVG_PRTE ',30);

11759: else
11760: --
11761: -- Call Update routine for the pk_id created in prev run .
11762: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11763: hr_utility.set_location(' BEN_ELIG_NO_OTHR_CVG_PRTE_F UPDATE_ELIG_NO_OTHR_CVG_PRTE ',30);
11764: --UPD START
11765: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11766: --
11767: if l_update then