APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_ENRLD_ANTHR_PTIP_F

Line 25633: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PTIP_F

25629: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25630: pqh_table_route tr
25631: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25632: and cpe.table_route_id = tr.table_route_id
25633: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PTIP_F
25634: and tr.table_alias = l_table_alias
25635: and cpe.number_of_copies = 1 -- ADDITION
25636: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
25637: order by information1, information2; --added for bug: 5151945

Line 25671: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET

25667: c_business_group_id number,
25668: c_new_pk_id number) is
25669: select
25670: EET.elig_enrld_anthr_ptip_id new_value
25671: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET
25672: where
25673: EET.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
25674: EET.PTIP_ID = l_PTIP_ID and
25675: EET.business_group_id = c_business_group_id

Line 25682: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET1

25678: and effective_end_date ;
25679: --END TEMPIK
25680: /*TEMPIK
25681: and exists ( select null
25682: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET1
25683: where
25684: EET1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
25685: EET1.PTIP_ID = l_PTIP_ID and
25686: EET1.business_group_id = c_business_group_id

Line 25689: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET2

25685: EET1.PTIP_ID = l_PTIP_ID and
25686: EET1.business_group_id = c_business_group_id
25687: and EET1.effective_start_date <= c_effective_start_date )
25688: and exists ( select null
25689: from BEN_ELIG_ENRLD_ANTHR_PTIP_F EET2
25690: where
25691: EET2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
25692: EET2.PTIP_ID = l_PTIP_ID and
25693: EET2.business_group_id = c_business_group_id

Line 25852: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PTIP_F',

25848: if c_find_EET_in_target%found then
25849: --
25850: --TEMPIK
25851: l_dt_rec_found := dt_api.check_min_max_dates
25852: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PTIP_F',
25853: p_base_key_column => 'ELIG_ENRLD_ANTHR_PTIP_ID',
25854: p_base_key_value => l_new_value,
25855: p_from_date => l_min_esd,
25856: p_to_date => l_max_eed );

Line 25912: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PTIP_F CREATE_ELIG_ENRLD_ANTHR_PTIP ',20);

25908: end if;
25909:
25910: if l_first_rec and not l_update then
25911: -- Call Create routine.
25912: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PTIP_F CREATE_ELIG_ENRLD_ANTHR_PTIP ',20);
25913: BEN_ELIG_ENRLD_ANTHR_PTIP_API.CREATE_ELIG_ENRLD_ANTHR_PTIP(
25914: --
25915: P_VALIDATE => false
25916: ,P_EFFECTIVE_DATE => l_effective_date

Line 25985: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PTIP_F UPDATE_ELIG_ENRLD_ANTHR_PTIP ',30);

25981: else
25982: --
25983: -- Call Update routine for the pk_id created in prev run .
25984: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
25985: hr_utility.set_location(' BEN_ELIG_ENRLD_ANTHR_PTIP_F UPDATE_ELIG_ENRLD_ANTHR_PTIP ',30);
25986: --UPD START
25987: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
25988: --
25989: if l_update then