DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;

30135: --
30136: l_ELIGY_PRFL_ID number;
30137: l_PRTT_DET_RL number;
30138:
30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;
30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;
30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;
30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;
30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;

Line 30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;

30136: l_ELIGY_PRFL_ID number;
30137: l_PRTT_DET_RL number;
30138:
30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;
30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;
30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;
30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;
30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;
30144:

Line 30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;

30137: l_PRTT_DET_RL number;
30138:
30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;
30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;
30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;
30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;
30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;
30144:
30145: cursor c_unique_ETP(l_table_alias varchar2) is

Line 30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;

30138:
30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;
30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;
30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;
30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;
30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;
30144:
30145: cursor c_unique_ETP(l_table_alias varchar2) is
30146: select distinct cpe.information1,

Line 30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;

30139: l_PRTT_DET_CD ben_elig_ttl_prtt_prte_f.prtt_det_cd%type;
30140: l_MN_PRTT_NUM ben_elig_ttl_prtt_prte_f.mn_prtt_num%type;
30141: l_MX_PRTT_NUM ben_elig_ttl_prtt_prte_f.mx_prtt_num%type;
30142: l_NO_MN_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mn_prtt_num_apls_flag%type;
30143: l_NO_MX_PRTT_NUM_APLS_FLAG ben_elig_ttl_prtt_prte_f.no_mx_prtt_num_apls_flag%type;
30144:
30145: cursor c_unique_ETP(l_table_alias varchar2) is
30146: select distinct cpe.information1,
30147: cpe.information2,

Line 30154: -- and tr.where_clause = l_BEN_ELIG_TTL_PRTT_PRTE_F

30150: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30151: pqh_table_route tr
30152: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30153: and cpe.table_route_id = tr.table_route_id
30154: -- and tr.where_clause = l_BEN_ELIG_TTL_PRTT_PRTE_F
30155: and tr.table_alias = l_table_alias
30156: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
30157: order by information1, information2; --added for bug: 5151945
30158: --

Line 30191: from BEN_ELIG_TTL_PRTT_PRTE_F ETP

30187: c_business_group_id number,
30188: c_new_pk_id number) is
30189: select
30190: ETP.elig_ttl_prtt_prte_id new_value
30191: from BEN_ELIG_TTL_PRTT_PRTE_F ETP
30192: where
30193: ETP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30194: nvl(ETP.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
30195: nvl(ETP.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 30207: from BEN_ELIG_TTL_PRTT_PRTE_F ETP1

30203: and effective_end_date ;
30204: --END TEMPIK
30205: /*TEMPIK
30206: and exists ( select null
30207: from BEN_ELIG_TTL_PRTT_PRTE_F ETP1
30208: where
30209: ETP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30210: nvl(ETP1.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
30211: nvl(ETP1.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 30219: from BEN_ELIG_TTL_PRTT_PRTE_F ETP2

30215: nvl(ETP1.NO_MN_PRTT_NUM_APLS_FLAG, '-YYYY') = nvl(l_NO_MN_PRTT_NUM_APLS_FLAG, '-YYYY') and
30216: ETP1.business_group_id = c_business_group_id
30217: and ETP1.effective_start_date <= c_effective_start_date )
30218: and exists ( select null
30219: from BEN_ELIG_TTL_PRTT_PRTE_F ETP2
30220: where
30221: ETP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
30222: nvl(ETP2.PRTT_DET_CD, '-YYYY') = nvl(l_PRTT_DET_CD, '-YYYY') and
30223: nvl(ETP2.PRTT_DET_RL, -999) = nvl(l_PRTT_DET_RL , -999)and

Line 30392: (p_base_table_name => 'BEN_ELIG_TTL_PRTT_PRTE_F',

30388: if c_find_ETP_in_target%found then
30389: --
30390: --TEMPIK
30391: l_dt_rec_found := dt_api.check_min_max_dates
30392: (p_base_table_name => 'BEN_ELIG_TTL_PRTT_PRTE_F',
30393: p_base_key_column => 'ELIG_TTL_PRTT_PRTE_ID',
30394: p_base_key_value => l_new_value,
30395: p_from_date => l_min_esd,
30396: p_to_date => l_max_eed );

Line 30452: hr_utility.set_location(' BEN_ELIG_TTL_PRTT_PRTE_F CREATE_ELIG_TTL_PRTT_PRTE ',20);

30448: end if;
30449:
30450: if l_first_rec and not l_update then
30451: -- Call Create routine.
30452: hr_utility.set_location(' BEN_ELIG_TTL_PRTT_PRTE_F CREATE_ELIG_TTL_PRTT_PRTE ',20);
30453: BEN_ELIG_TTL_PRTT_PRTE_API.CREATE_ELIG_TTL_PRTT_PRTE(
30454: --
30455: P_VALIDATE => false
30456: ,P_EFFECTIVE_DATE => l_effective_date

Line 30528: hr_utility.set_location(' BEN_ELIG_TTL_PRTT_PRTE_F UPDATE_ELIG_TTL_PRTT_PRTE ',30);

30524: else
30525: --
30526: -- Call Update routine for the pk_id created in prev run .
30527: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
30528: hr_utility.set_location(' BEN_ELIG_TTL_PRTT_PRTE_F UPDATE_ELIG_TTL_PRTT_PRTE ',30);
30529: --UPD START
30530: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
30531: --
30532: if l_update then