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_TTL_CVG_VOL_PRTE_F

Line 30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;

30665: --
30666: l_CVG_VOL_DET_RL number;
30667: l_ELIGY_PRFL_ID number;
30668:
30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;
30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;
30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;
30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;
30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;

Line 30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;

30666: l_CVG_VOL_DET_RL number;
30667: l_ELIGY_PRFL_ID number;
30668:
30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;
30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;
30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;
30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;
30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;
30674:

Line 30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;

30667: l_ELIGY_PRFL_ID number;
30668:
30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;
30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;
30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;
30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;
30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;
30674:
30675: cursor c_unique_ETC(l_table_alias varchar2) is

Line 30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;

30668:
30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;
30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;
30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;
30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;
30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;
30674:
30675: cursor c_unique_ETC(l_table_alias varchar2) is
30676: select distinct cpe.information1,

Line 30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;

30669: l_CVG_VOL_DET_CD ben_elig_ttl_cvg_vol_prte_f.cvg_vol_det_cd%type;
30670: l_MN_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mn_cvg_vol_amt%type;
30671: l_MX_CVG_VOL_AMT ben_elig_ttl_cvg_vol_prte_f.mx_cvg_vol_amt%type;
30672: l_NO_MN_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mn_cvg_vol_amt_apls_flag%type;
30673: l_NO_MX_CVG_VOL_AMT_APLS_FLAG ben_elig_ttl_cvg_vol_prte_f.no_mx_cvg_vol_amt_apls_flag%type;
30674:
30675: cursor c_unique_ETC(l_table_alias varchar2) is
30676: select distinct cpe.information1,
30677: cpe.information2,

Line 30684: -- and tr.where_clause = l_BEN_ELIG_TTL_CVG_VOL_PRTE_F

30680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30681: pqh_table_route tr
30682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30683: and cpe.table_route_id = tr.table_route_id
30684: -- and tr.where_clause = l_BEN_ELIG_TTL_CVG_VOL_PRTE_F
30685: and tr.table_alias = l_table_alias
30686: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
30687: order by information1, information2; --added for bug: 5151945
30688: --

Line 30721: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC

30717: c_business_group_id number,
30718: c_new_pk_id number) is
30719: select
30720: ETC.elig_ttl_cvg_vol_prte_id new_value
30721: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC
30722: where
30723: ETC.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30724: nvl(ETC.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
30725: nvl(ETC.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 30737: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC1

30733: and effective_end_date ;
30734: --END TEMPIK
30735: /*TEMPIK
30736: and exists ( select null
30737: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC1
30738: where
30739: ETC1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30740: nvl(ETC1.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
30741: nvl(ETC1.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 30749: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC2

30745: nvl(ETC1.NO_MX_CVG_VOL_AMT_APLS_FLAG, '-YYYY') = nvl(l_NO_MX_CVG_VOL_AMT_APLS_FLAG, '-YYYY') and
30746: ETC1.business_group_id = c_business_group_id
30747: and ETC1.effective_start_date <= c_effective_start_date )
30748: and exists ( select null
30749: from BEN_ELIG_TTL_CVG_VOL_PRTE_F ETC2
30750: where
30751: ETC2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30752: nvl(ETC2.CVG_VOL_DET_CD, '-YYYY') = nvl(l_CVG_VOL_DET_CD, '-YYYY') and
30753: nvl(ETC2.CVG_VOL_DET_RL, -999) = nvl(l_CVG_VOL_DET_RL , -999)and

Line 30923: (p_base_table_name => 'BEN_ELIG_TTL_CVG_VOL_PRTE_F',

30919: if c_find_ETC_in_target%found then
30920: --
30921: --TEMPIK
30922: l_dt_rec_found := dt_api.check_min_max_dates
30923: (p_base_table_name => 'BEN_ELIG_TTL_CVG_VOL_PRTE_F',
30924: p_base_key_column => 'ELIG_TTL_CVG_VOL_PRTE_ID',
30925: p_base_key_value => l_new_value,
30926: p_from_date => l_min_esd,
30927: p_to_date => l_max_eed );

Line 30983: hr_utility.set_location(' BEN_ELIG_TTL_CVG_VOL_PRTE_F CREATE_ELIG_TTL_CVG_VOL_PRTE ',20);

30979: end if;
30980:
30981: if l_first_rec and not l_update then
30982: -- Call Create routine.
30983: hr_utility.set_location(' BEN_ELIG_TTL_CVG_VOL_PRTE_F CREATE_ELIG_TTL_CVG_VOL_PRTE ',20);
30984: BEN_ELIG_TTL_CVG_VOL_PRTE_API.CREATE_ELIG_TTL_CVG_VOL_PRTE(
30985: --
30986: P_VALIDATE => false
30987: ,P_EFFECTIVE_DATE => l_effective_date

Line 31059: hr_utility.set_location(' BEN_ELIG_TTL_CVG_VOL_PRTE_F UPDATE_ELIG_TTL_CVG_VOL_PRTE ',30);

31055: else
31056: --
31057: -- Call Update routine for the pk_id created in prev run .
31058: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
31059: hr_utility.set_location(' BEN_ELIG_TTL_CVG_VOL_PRTE_F UPDATE_ELIG_TTL_CVG_VOL_PRTE ',30);
31060: --UPD START
31061: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
31062: --
31063: if l_update then