APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_MRTL_STS_PRTE_F

Line 10917: l_MARITAL_STATUS ben_elig_mrtl_sts_prte_f.marital_status%type;

10913: ,p_prefix_suffix_cd in varchar2 default null
10914: ) is
10915: --
10916: l_ELIGY_PRFL_ID number;
10917: l_MARITAL_STATUS ben_elig_mrtl_sts_prte_f.marital_status%type;
10918:
10919: cursor c_unique_EMP(l_table_alias varchar2) is
10920: select distinct cpe.information1,
10921: cpe.information2,

Line 10928: -- and tr.where_clause = l_BEN_ELIG_MRTL_STS_PRTE_F

10924: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10925: pqh_table_route tr
10926: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10927: and cpe.table_route_id = tr.table_route_id
10928: -- and tr.where_clause = l_BEN_ELIG_MRTL_STS_PRTE_F
10929: and tr.table_alias = l_table_alias
10930: and cpe.number_of_copies = 1 -- ADDITION
10931: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
10932: order by information1, information2; --added for bug: 5151945

Line 10966: from BEN_ELIG_MRTL_STS_PRTE_F EMP

10962: c_business_group_id number,
10963: c_new_pk_id number) is
10964: select
10965: EMP.elig_mrtl_sts_prte_id new_value
10966: from BEN_ELIG_MRTL_STS_PRTE_F EMP
10967: where
10968: EMP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
10969: EMP.business_group_id = c_business_group_id and
10970: EMP.MARITAL_STATUS = l_MARITAL_STATUS and

Line 10977: from BEN_ELIG_MRTL_STS_PRTE_F EMP1

10973: and effective_end_date ;
10974: --END TEMPIK
10975: /*TEMPIK
10976: and exists ( select null
10977: from BEN_ELIG_MRTL_STS_PRTE_F EMP1
10978: where
10979: EMP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
10980: EMP1.MARITAL_STATUS = l_MARITAL_STATUS and
10981: EMP1.business_group_id = c_business_group_id

Line 10984: from BEN_ELIG_MRTL_STS_PRTE_F EMP2

10980: EMP1.MARITAL_STATUS = l_MARITAL_STATUS and
10981: EMP1.business_group_id = c_business_group_id
10982: and EMP1.effective_start_date <= c_effective_start_date )
10983: and exists ( select null
10984: from BEN_ELIG_MRTL_STS_PRTE_F EMP2
10985: where
10986: EMP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
10987: EMP2.MARITAL_STATUS = l_MARITAL_STATUS and
10988: EMP2.business_group_id = c_business_group_id

Line 11141: (p_base_table_name => 'BEN_ELIG_MRTL_STS_PRTE_F',

11137: if c_find_EMP_in_target%found then
11138: --
11139: --TEMPIK
11140: l_dt_rec_found := dt_api.check_min_max_dates
11141: (p_base_table_name => 'BEN_ELIG_MRTL_STS_PRTE_F',
11142: p_base_key_column => 'ELIG_MRTL_STS_PRTE_ID',
11143: p_base_key_value => l_new_value,
11144: p_from_date => l_min_esd,
11145: p_to_date => l_max_eed );

Line 11201: hr_utility.set_location(' BEN_ELIG_MRTL_STS_PRTE_F CREATE_ELIG_MRTL_STS_PRTE ',20);

11197: end if;
11198:
11199: if l_first_rec and not l_update then
11200: -- Call Create routine.
11201: hr_utility.set_location(' BEN_ELIG_MRTL_STS_PRTE_F CREATE_ELIG_MRTL_STS_PRTE ',20);
11202: BEN_ELIG_MRTL_STS_PRTE_API.CREATE_ELIG_MRTL_STS_PRTE(
11203: --
11204: P_VALIDATE => false
11205: ,P_EFFECTIVE_DATE => l_effective_date

Line 11273: hr_utility.set_location(' BEN_ELIG_MRTL_STS_PRTE_F UPDATE_ELIG_MRTL_STS_PRTE ',30);

11269: else
11270: --
11271: -- Call Update routine for the pk_id created in prev run .
11272: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11273: hr_utility.set_location(' BEN_ELIG_MRTL_STS_PRTE_F UPDATE_ELIG_MRTL_STS_PRTE ',30);
11274: --UPD START
11275: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11276: --
11277: if l_update then