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_SCHEDD_HRS_PRTE_F

Line 18992: -- and tr.where_clause = l_BEN_ELIG_SCHEDD_HRS_PRTE_F

18988: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18989: pqh_table_route tr
18990: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18991: and cpe.table_route_id = tr.table_route_id
18992: -- and tr.where_clause = l_BEN_ELIG_SCHEDD_HRS_PRTE_F
18993: and tr.table_alias = l_table_alias
18994: and cpe.number_of_copies = 1 -- ADDITION
18995: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
18996: order by information1, information2; --added for bug: 5151945

Line 19030: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH

19026: c_business_group_id number,
19027: c_new_pk_id number) is
19028: select
19029: ESH.elig_schedd_hrs_prte_id new_value
19030: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH
19031: where
19032: ESH.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
19033: NVL(ESH.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
19034: NVL(ESH.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 19049: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH1

19045: and effective_end_date ;
19046: --END TEMPIK
19047: /*TEMPIK
19048: and exists ( select null
19049: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH1
19050: where
19051: ESH1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
19052: NVL(ESH1.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
19053: NVL(ESH1.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 19064: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH2

19060: ESH1.ORDR_NUM = l_ORDR_NUM and
19061: ESH1.business_group_id = c_business_group_id
19062: and ESH1.effective_start_date <= c_effective_start_date )
19063: and exists ( select null
19064: from BEN_ELIG_SCHEDD_HRS_PRTE_F ESH2
19065: where
19066: ESH2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
19067: NVL(ESH2.HRS_NUM,-999) = NVL(l_HRS_NUM,-999) and
19068: NVL(ESH2.FREQ_CD,-999) = NVL(l_FREQ_CD,-999) and

Line 19245: (p_base_table_name => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',

19241: if c_find_ESH_in_target%found then
19242: --
19243: --TEMPIK
19244: l_dt_rec_found := dt_api.check_min_max_dates
19245: (p_base_table_name => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
19246: p_base_key_column => 'ELIG_SCHEDD_HRS_PRTE_ID',
19247: p_base_key_value => l_new_value,
19248: p_from_date => l_min_esd,
19249: p_to_date => l_max_eed );

Line 19305: hr_utility.set_location(' BEN_ELIG_SCHEDD_HRS_PRTE_F CREATE_ELIG_SCHEDD_HRS_PRTE ',20);

19301: end if;
19302:
19303: if l_first_rec and not l_update then
19304: -- Call Create routine.
19305: hr_utility.set_location(' BEN_ELIG_SCHEDD_HRS_PRTE_F CREATE_ELIG_SCHEDD_HRS_PRTE ',20);
19306: BEN_ELIG_SCHEDD_HRS_PRTE_API.CREATE_ELIG_SCHEDD_HRS_PRTE(
19307: --
19308: P_VALIDATE => false
19309: ,P_EFFECTIVE_DATE => l_effective_date

Line 19385: hr_utility.set_location(' BEN_ELIG_SCHEDD_HRS_PRTE_F UPDATE_ELIG_SCHEDD_HRS_PRTE ',30);

19381: else
19382: --
19383: -- Call Update routine for the pk_id created in prev run .
19384: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
19385: hr_utility.set_location(' BEN_ELIG_SCHEDD_HRS_PRTE_F UPDATE_ELIG_SCHEDD_HRS_PRTE ',30);
19386: --UPD START
19387: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
19388: --
19389: if l_update then