APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_GNDR_PRTE_F

Line 28656: l_SEX ben_elig_gndr_prte_f.sex%type;

28652: ,p_prefix_suffix_cd in varchar2 default null
28653: ) is
28654: --
28655: l_ELIGY_PRFL_ID number;
28656: l_SEX ben_elig_gndr_prte_f.sex%type;
28657: l_ORDR_NUM ben_elig_gndr_prte_f.ordr_num%type;
28658: cursor c_unique_EGN(l_table_alias varchar2) is
28659: select distinct cpe.information1,
28660: cpe.information2,

Line 28657: l_ORDR_NUM ben_elig_gndr_prte_f.ordr_num%type;

28653: ) is
28654: --
28655: l_ELIGY_PRFL_ID number;
28656: l_SEX ben_elig_gndr_prte_f.sex%type;
28657: l_ORDR_NUM ben_elig_gndr_prte_f.ordr_num%type;
28658: cursor c_unique_EGN(l_table_alias varchar2) is
28659: select distinct cpe.information1,
28660: cpe.information2,
28661: cpe.information3,

Line 28667: -- and tr.where_clause = l_BEN_ELIG_GNDR_PRTE_F

28663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28664: pqh_table_route tr
28665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28666: and cpe.table_route_id = tr.table_route_id
28667: -- and tr.where_clause = l_BEN_ELIG_GNDR_PRTE_F
28668: and tr.table_alias = l_table_alias
28669: and cpe.number_of_copies = 1 -- ADDITION
28670: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
28671: order by information1, information2; --added for bug: 5151945

Line 28705: from BEN_ELIG_GNDR_PRTE_F EGN

28701: c_business_group_id number,
28702: c_new_pk_id number) is
28703: select
28704: EGN.elig_gndr_prte_id new_value
28705: from BEN_ELIG_GNDR_PRTE_F EGN
28706: where
28707: EGN.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28708: EGN.sex = l_SEX and
28709: EGN.ordr_num = l_ORDR_NUM and

Line 28717: from BEN_ELIG_GNDR_PRTE_F EGN1

28713: and effective_end_date ;
28714: --END TEMPIK
28715: /*TEMPIK
28716: and exists ( select null
28717: from BEN_ELIG_GNDR_PRTE_F EGN1
28718: where
28719: EGN1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28720: EGN1.sex = l_SEX and
28721: EGN1.ordr_num = l_ORDR_NUM and

Line 28725: from BEN_ELIG_GNDR_PRTE_F EGN2

28721: EGN1.ordr_num = l_ORDR_NUM and
28722: EGN1.business_group_id = c_business_group_id
28723: and EGN1.effective_start_date <= c_effective_start_date )
28724: and exists ( select null
28725: from BEN_ELIG_GNDR_PRTE_F EGN2
28726: where
28727: EGN2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
28728: EGN2.sex = l_SEX and
28729: EGN2.ordr_num = l_ORDR_NUM and

Line 28885: (p_base_table_name => 'BEN_ELIG_GNDR_PRTE_F',

28881: if c_find_EGN_in_target%found then
28882: --
28883: --TEMPIK
28884: l_dt_rec_found := dt_api.check_min_max_dates
28885: (p_base_table_name => 'BEN_ELIG_GNDR_PRTE_F',
28886: p_base_key_column => 'ELIG_GNDR_PRTE_ID',
28887: p_base_key_value => l_new_value,
28888: p_from_date => l_min_esd,
28889: p_to_date => l_max_eed );

Line 28945: hr_utility.set_location(' BEN_ELIG_GNDR_PRTE_F CREATE_ELIG_GNDR_PRTE ',20);

28941: end if;
28942:
28943: if l_first_rec and not l_update then
28944: -- Call Create routine.
28945: hr_utility.set_location(' BEN_ELIG_GNDR_PRTE_F CREATE_ELIG_GNDR_PRTE ',20);
28946: BEN_ELIG_GNDR_PRTE_API.CREATE_ELIG_GNDR_PRTE(
28947: --
28948: P_VALIDATE => false
28949: ,P_EFFECTIVE_DATE => l_effective_date

Line 29018: hr_utility.set_location(' BEN_ELIG_GNDR_PRTE_F UPDATE_ELIG_GNDR_PRTE ',30);

29014: else
29015: --
29016: -- Call Update routine for the pk_id created in prev run .
29017: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
29018: hr_utility.set_location(' BEN_ELIG_GNDR_PRTE_F UPDATE_ELIG_GNDR_PRTE ',30);
29019: --UPD START
29020: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
29021: --
29022: if l_update then