eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_PERF_RTNG_PRTE_F

Line 27654: l_EVENT_TYPE ben_elig_perf_rtng_prte_f.event_type%type;

27650: ,p_prefix_suffix_cd in varchar2 default null
27651: ) is
27652: --
27653: l_ELIGY_PRFL_ID number;
27654: l_EVENT_TYPE ben_elig_perf_rtng_prte_f.event_type%type;
27655: l_ORDR_NUM ben_elig_perf_rtng_prte_f.ordr_num%type;
27656: l_PERF_RTNG_CD ben_elig_perf_rtng_prte_f.perf_rtng_cd%type;
27657:
27658: cursor c_unique_ERG(l_table_alias varchar2) is

Line 27655: l_ORDR_NUM ben_elig_perf_rtng_prte_f.ordr_num%type;

27651: ) is
27652: --
27653: l_ELIGY_PRFL_ID number;
27654: l_EVENT_TYPE ben_elig_perf_rtng_prte_f.event_type%type;
27655: l_ORDR_NUM ben_elig_perf_rtng_prte_f.ordr_num%type;
27656: l_PERF_RTNG_CD ben_elig_perf_rtng_prte_f.perf_rtng_cd%type;
27657:
27658: cursor c_unique_ERG(l_table_alias varchar2) is
27659: select distinct cpe.information1,

Line 27656: l_PERF_RTNG_CD ben_elig_perf_rtng_prte_f.perf_rtng_cd%type;

27652: --
27653: l_ELIGY_PRFL_ID number;
27654: l_EVENT_TYPE ben_elig_perf_rtng_prte_f.event_type%type;
27655: l_ORDR_NUM ben_elig_perf_rtng_prte_f.ordr_num%type;
27656: l_PERF_RTNG_CD ben_elig_perf_rtng_prte_f.perf_rtng_cd%type;
27657:
27658: cursor c_unique_ERG(l_table_alias varchar2) is
27659: select distinct cpe.information1,
27660: cpe.information2,

Line 27667: -- and tr.where_clause = l_BEN_ELIG_PERF_RTNG_PRTE_F

27663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27664: pqh_table_route tr
27665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27666: and cpe.table_route_id = tr.table_route_id
27667: -- and tr.where_clause = l_BEN_ELIG_PERF_RTNG_PRTE_F
27668: and tr.table_alias = l_table_alias
27669: and cpe.number_of_copies = 1 -- ADDITION
27670: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
27671: order by information1, information2; --added for bug: 5151945

Line 27705: from BEN_ELIG_PERF_RTNG_PRTE_F ERG

27701: c_business_group_id number,
27702: c_new_pk_id number) is
27703: select
27704: ERG.elig_perf_rtng_prte_id new_value
27705: from BEN_ELIG_PERF_RTNG_PRTE_F ERG
27706: where
27707: ERG.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27708: ERG.EVENT_TYPE = l_EVENT_TYPE and
27709: ERG.ORDR_NUM = l_ORDR_NUM and

Line 27718: from BEN_ELIG_PERF_RTNG_PRTE_F ERG1

27714: and effective_end_date ;
27715: --END TEMPIK
27716: /*TEMPIK
27717: and exists ( select null
27718: from BEN_ELIG_PERF_RTNG_PRTE_F ERG1
27719: where
27720: ERG1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27721: ERG1.EVENT_TYPE = l_EVENT_TYPE and
27722: ERG1.ORDR_NUM = l_ORDR_NUM and

Line 27727: from BEN_ELIG_PERF_RTNG_PRTE_F ERG2

27723: ERG1.PERF_RTNG_CD = l_PERF_RTNG_CD and
27724: ERG1.business_group_id = c_business_group_id
27725: and ERG1.effective_start_date <= c_effective_start_date )
27726: and exists ( select null
27727: from BEN_ELIG_PERF_RTNG_PRTE_F ERG2
27728: where
27729: ERG2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
27730: ERG2.EVENT_TYPE = l_EVENT_TYPE and
27731: ERG2.ORDR_NUM = l_ORDR_NUM and

Line 27888: (p_base_table_name => 'BEN_ELIG_PERF_RTNG_PRTE_F',

27884: if c_find_ERG_in_target%found then
27885: --
27886: --TEMPIK
27887: l_dt_rec_found := dt_api.check_min_max_dates
27888: (p_base_table_name => 'BEN_ELIG_PERF_RTNG_PRTE_F',
27889: p_base_key_column => 'ELIG_PERF_RTNG_PRTE_ID',
27890: p_base_key_value => l_new_value,
27891: p_from_date => l_min_esd,
27892: p_to_date => l_max_eed );

Line 27948: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);

27944: end if;
27945:
27946: if l_first_rec and not l_update then
27947: -- Call Create routine.
27948: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);
27949: BEN_ELIG_PERF_RTNG_PRTE_API.CREATE_ELIG_PERF_RTNG_PRTE(
27950: --
27951: P_VALIDATE => false
27952: ,P_EFFECTIVE_DATE => l_effective_date

Line 28022: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F UPDATE_ELIG_PERF_RTNG_PRTE ',30);

28018: else
28019: --
28020: -- Call Update routine for the pk_id created in prev run .
28021: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
28022: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F UPDATE_ELIG_PERF_RTNG_PRTE ',30);
28023: --UPD START
28024: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
28025: --
28026: if l_update then