APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PRTN_ELIGY_RL_F

Line 12062: -- and tr.where_clause = l_BEN_PRTN_ELIGY_RL_F

12058: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12059: pqh_table_route tr
12060: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12061: and cpe.table_route_id = tr.table_route_id
12062: -- and tr.where_clause = l_BEN_PRTN_ELIGY_RL_F
12063: and tr.table_alias = l_table_alias
12064: and cpe.number_of_copies = 1 -- ADDITION
12065: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12066: order by information1, information2; --added for bug: 5151945

Line 12100: from BEN_PRTN_ELIGY_RL_F CER

12096: c_business_group_id number,
12097: c_new_pk_id number) is
12098: select
12099: cer.prtn_eligy_rl_id new_value
12100: from BEN_PRTN_ELIGY_RL_F CER
12101: where
12102: cer.FORMULA_ID = l_FORMULA_ID and
12103: cer.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12104: cer.business_group_id = c_business_group_id

Line 12112: from BEN_PRTN_ELIGY_RL_F CER1

12108: and effective_end_date ;
12109: --END TEMPIK
12110: /*TEMPIK
12111: and exists ( select null
12112: from BEN_PRTN_ELIGY_RL_F CER1
12113: where
12114: CER1.FORMULA_ID = l_FORMULA_ID and
12115: CER1.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12116: CER1.business_group_id = c_business_group_id

Line 12119: from BEN_PRTN_ELIGY_RL_F CER2

12115: CER1.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12116: CER1.business_group_id = c_business_group_id
12117: and CER1.effective_start_date <= c_effective_start_date )
12118: and exists ( select null
12119: from BEN_PRTN_ELIGY_RL_F CER2
12120: where
12121: CER2.FORMULA_ID = l_FORMULA_ID and
12122: CER2.PRTN_ELIG_ID = l_PRTN_ELIG_ID and
12123: CER2.business_group_id = c_business_group_id

Line 12266: (p_base_table_name => 'BEN_PRTN_ELIGY_RL_F',

12262: if c_find_CER_in_target%found then
12263: --
12264: --TEMPIK
12265: l_dt_rec_found := dt_api.check_min_max_dates
12266: (p_base_table_name => 'BEN_PRTN_ELIGY_RL_F',
12267: p_base_key_column => 'PRTN_ELIGY_RL_ID',
12268: p_base_key_value => l_new_value,
12269: p_from_date => l_min_esd,
12270: p_to_date => l_max_eed );

Line 12325: hr_utility.set_location(' BEN_PRTN_ELIGY_RL_F CREATE_ELIGIBILITY_RULE ',20);

12321: end if;
12322:
12323: if l_first_rec and not l_update then
12324: -- Call Create routine.
12325: hr_utility.set_location(' BEN_PRTN_ELIGY_RL_F CREATE_ELIGIBILITY_RULE ',20);
12326: BEN_ELIGIBILITY_RULE_API.CREATE_ELIGIBILITY_RULE(
12327: --
12328: P_VALIDATE => false
12329: ,P_EFFECTIVE_DATE => l_effective_date

Line 12393: hr_utility.set_location(' BEN_PRTN_ELIGY_RL_F UPDATE_ELIGIBILITY_RULE ',30);

12389: else
12390: --
12391: -- Call Update routine for the pk_id created in prev run .
12392: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12393: hr_utility.set_location(' BEN_PRTN_ELIGY_RL_F UPDATE_ELIGIBILITY_RULE ',30);
12394: --UPD START
12395: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12396: --
12397: if l_update then