APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 7892: -- and tr.where_clause = l_BEN_ACTL_PREM_VRBL_RT_RL_F

7888: from ben_copy_entity_results cpe,
7889: pqh_table_route tr
7890: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7891: and cpe.table_route_id = tr.table_route_id
7892: -- and tr.where_clause = l_BEN_ACTL_PREM_VRBL_RT_RL_F
7893: and tr.table_alias = l_table_alias
7894: and cpe.number_of_copies = 1 -- ADDITION
7895: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7896: order by information1, information2; --added for bug: 5151945

Line 7930: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA

7926: c_business_group_id number,
7927: c_new_pk_id number) is
7928: select
7929: AVA.actl_prem_vrbl_rt_rl_id new_value
7930: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA
7931: where
7932: AVA.ACTL_PREM_ID = l_ACTL_PREM_ID and
7933: AVA.FORMULA_ID = l_FORMULA_ID and
7934: AVA.business_group_id = c_business_group_id

Line 7942: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA1

7938: and effective_end_date ;
7939: --END TEMPIK
7940: /*TEMPIK
7941: and exists ( select null
7942: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA1
7943: where
7944: AVA1.ACTL_PREM_ID = l_ACTL_PREM_ID and
7945: AVA1.FORMULA_ID = l_FORMULA_ID and
7946: AVA1.business_group_id = c_business_group_id

Line 7949: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA2

7945: AVA1.FORMULA_ID = l_FORMULA_ID and
7946: AVA1.business_group_id = c_business_group_id
7947: and AVA1.effective_start_date <= c_effective_start_date )
7948: and exists ( select null
7949: from BEN_ACTL_PREM_VRBL_RT_RL_F AVA2
7950: where
7951: AVA2.ACTL_PREM_ID = l_ACTL_PREM_ID and
7952: AVA2.FORMULA_ID = l_FORMULA_ID and
7953: AVA2.business_group_id = c_business_group_id

Line 8099: (p_base_table_name => 'BEN_ACTL_PREM_VRBL_RT_RL_F',

8095: if c_find_AVA_in_target%found then
8096: --
8097: --TEMPIK
8098: l_dt_rec_found := dt_api.check_min_max_dates
8099: (p_base_table_name => 'BEN_ACTL_PREM_VRBL_RT_RL_F',
8100: p_base_key_column => 'ACTL_PREM_VRBL_RT_RL_ID',
8101: p_base_key_value => l_new_value,
8102: p_from_date => l_min_esd,
8103: p_to_date => l_max_eed );

Line 8166: hr_utility.set_location(' BEN_ACTL_PREM_VRBL_RT_RL_F CREATE_ACTUAL_PREMIUM_RULE ',20);

8162: if l_first_rec and not l_update then
8163: -- UPD END
8164:
8165: -- Call Create routine.
8166: hr_utility.set_location(' BEN_ACTL_PREM_VRBL_RT_RL_F CREATE_ACTUAL_PREMIUM_RULE ',20);
8167: BEN_ACTUAL_PREMIUM_RULE_API.CREATE_ACTUAL_PREMIUM_RULE(
8168: --
8169: P_VALIDATE => false
8170: ,P_EFFECTIVE_DATE => l_effective_date

Line 8233: hr_utility.set_location(' BEN_ACTL_PREM_VRBL_RT_RL_F UPDATE_ACTUAL_PREMIUM_RULE ',30);

8229: else
8230: --
8231: -- Call Update routine for the pk_id created in prev run .
8232: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8233: hr_utility.set_location(' BEN_ACTL_PREM_VRBL_RT_RL_F UPDATE_ACTUAL_PREMIUM_RULE ',30);
8234: --UPD START
8235: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8236: --
8237: if l_update then