APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_OIPL_F

Line 23151: -- and tr.where_clause = l_BEN_OIPL_F

23147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23148: pqh_table_route tr
23149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23150: and cpe.table_route_id = tr.table_route_id
23151: -- and tr.where_clause = l_BEN_OIPL_F
23152: and tr.table_alias = l_table_alias
23153: and cpe.number_of_copies = 1 -- ADDITION
23154: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
23155: ORDER BY cpe.information1,cpe.information2; -- 5122908. Records need to be created ordered on effective date.

Line 23189: from BEN_OIPL_F COP

23185: c_business_group_id number,
23186: c_new_pk_id number) is
23187: select
23188: COP.oipl_id new_value
23189: from BEN_OIPL_F COP
23190: where
23191: COP.OPT_ID = l_OPT_ID and
23192: COP.PL_ID = l_PL_ID and
23193: nvl(COP.ACTL_PREM_ID,-999) = nvl(l_ACTL_PREM_ID,-999) and

Line 23202: from BEN_OIPL_F COP1

23198: and effective_end_date ;
23199: --END TEMPIK
23200: /*
23201: and exists ( select null
23202: from BEN_OIPL_F COP1
23203: where
23204: COP1.OPT_ID = l_OPT_ID and
23205: COP1.PL_ID = l_PL_ID and
23206: nvl(COP1.ACTL_PREM_ID,-999) = nvl(l_ACTL_PREM_ID,-999) and

Line 23210: from BEN_OIPL_F COP2

23206: nvl(COP1.ACTL_PREM_ID,-999) = nvl(l_ACTL_PREM_ID,-999) and
23207: COP1.business_group_id = c_business_group_id
23208: and COP1.effective_start_date <= c_effective_start_date )
23209: and exists ( select null
23210: from BEN_OIPL_F COP2
23211: where
23212: COP2.OPT_ID = l_OPT_ID and
23213: COP2.PL_ID = l_PL_ID and
23214: nvl(COP2.ACTL_PREM_ID,-999) = nvl(l_ACTL_PREM_ID,-999) and

Line 23367: (p_base_table_name => 'BEN_OIPL_F',

23363: if c_find_COP_in_target%found then
23364: --
23365: --TEMPIK
23366: l_dt_rec_found := dt_api.check_min_max_dates
23367: (p_base_table_name => 'BEN_OIPL_F',
23368: p_base_key_column => 'OIPL_ID',
23369: p_base_key_value => l_new_value,
23370: p_from_date => l_min_esd,
23371: p_to_date => l_max_eed );

Line 23426: hr_utility.set_location(' BEN_OIPL_F CREATE_OPTION_IN_PLAN ',20);

23422: end if;
23423:
23424: if l_first_rec and not l_update then
23425: -- Call Create routine.
23426: hr_utility.set_location(' BEN_OIPL_F CREATE_OPTION_IN_PLAN ',20);
23427: BEN_OPTION_IN_PLAN_API.CREATE_OPTION_IN_PLAN(
23428: --
23429: P_VALIDATE => false
23430: ,P_EFFECTIVE_DATE => l_effective_date

Line 23525: hr_utility.set_location(' BEN_OIPL_F UPDATE_OPTION_IN_PLAN ',30);

23521: else
23522: --
23523: -- Call Update routine for the pk_id created in prev run .
23524: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
23525: hr_utility.set_location(' BEN_OIPL_F UPDATE_OPTION_IN_PLAN ',30);
23526: --UPD START
23527: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
23528: --
23529: if l_update then

Line 24725: -- NEVER CREATE HERE. THIS IS DONE IN BEN_PLIP_F and BEN_OIPL_F apis.

24721: -- end if ;
24722: --
24723: close c_OPP_min_max_dates ;
24724: --
24725: -- NEVER CREATE HERE. THIS IS DONE IN BEN_PLIP_F and BEN_OIPL_F apis.
24726: /*
24727: if not l_object_found_in_target then
24728: --
24729: l_current_pk_id := r_OPP.information1;

Line 25121: -- NEVER CREATE HERE. THIS IS DONE IN BEN_OIPL_F, BEN_PLIP_F, BEN_OPT_F and BEN_PTIP_F apis.

25117: end if;
25118: -- end if ;
25119: --
25120: close c_OTP_min_max_dates ;
25121: -- NEVER CREATE HERE. THIS IS DONE IN BEN_OIPL_F, BEN_PLIP_F, BEN_OPT_F and BEN_PTIP_F apis.
25122: /*
25123: if not l_object_found_in_target then
25124: --
25125: l_current_pk_id := r_OTP.information1;