APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 13905: -- and tr.where_clause = l_BEN_ELIG_PER_TYP_PRTE_F

13901: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13902: pqh_table_route tr
13903: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13904: and cpe.table_route_id = tr.table_route_id
13905: -- and tr.where_clause = l_BEN_ELIG_PER_TYP_PRTE_F
13906: and tr.table_alias = l_table_alias
13907: and cpe.number_of_copies = 1 -- ADDITION
13908: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13909: order by information1, information2; --added for bug: 5151945

Line 13943: from BEN_ELIG_PER_TYP_PRTE_F EPT

13939: c_business_group_id number,
13940: c_new_pk_id number) is
13941: select
13942: EPT.elig_per_typ_prte_id new_value
13943: from BEN_ELIG_PER_TYP_PRTE_F EPT
13944: where
13945: EPT.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
13946: EPT.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
13947: EPT.ordr_num = l_ORDR_NUM and

Line 13955: from BEN_ELIG_PER_TYP_PRTE_F EPT1

13951: and effective_end_date ;
13952: --END TEMPIK
13953: /*TEMPIK
13954: and exists ( select null
13955: from BEN_ELIG_PER_TYP_PRTE_F EPT1
13956: where
13957: EPT1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
13958: EPT1.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
13959: EPT1.ordr_num = l_ORDR_NUM and -- Added this criteria

Line 13963: from BEN_ELIG_PER_TYP_PRTE_F EPT2

13959: EPT1.ordr_num = l_ORDR_NUM and -- Added this criteria
13960: EPT1.business_group_id = c_business_group_id
13961: and EPT1.effective_start_date <= c_effective_start_date )
13962: and exists ( select null
13963: from BEN_ELIG_PER_TYP_PRTE_F EPT2
13964: where
13965: EPT2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
13966: EPT2.PERSON_TYPE_ID = l_PERSON_TYPE_ID and
13967: EPT2.ordr_num = l_ORDR_NUM and -- Added this criteria

Line 14146: (p_base_table_name => 'BEN_ELIG_PER_TYP_PRTE_F',

14142: if c_find_EPT_in_target%found then
14143: --
14144: --TEMPIK
14145: l_dt_rec_found := dt_api.check_min_max_dates
14146: (p_base_table_name => 'BEN_ELIG_PER_TYP_PRTE_F',
14147: p_base_key_column => 'ELIG_PER_TYP_PRTE_ID',
14148: p_base_key_value => l_new_value,
14149: p_from_date => l_min_esd,
14150: p_to_date => l_max_eed );

Line 14207: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);

14203: end if;
14204:
14205: if l_first_rec and not l_update then
14206: -- Call Create routine.
14207: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);
14208: BEN_ELIG_PER_TYP_PRTE_API.CREATE_ELIG_PER_TYP_PRTE(
14209: --
14210: P_VALIDATE => false
14211: ,P_EFFECTIVE_DATE => l_effective_date

Line 14281: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F UPDATE_ELIG_PER_TYP_PRTE ',30);

14277: else
14278: --
14279: -- Call Update routine for the pk_id created in prev run .
14280: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
14281: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F UPDATE_ELIG_PER_TYP_PRTE ',30);
14282: --UPD START
14283: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
14284: --
14285: if l_update then