APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_REGY_BOD_F

Line 217: l_regy_pl_name BEN_PL_REGY_BOD_F.regy_pl_name%type;

213: ) is
214: --
215: l_PL_ID number;
216: l_RPTG_GRP_ID number;
217: l_regy_pl_name BEN_PL_REGY_BOD_F.regy_pl_name%type;
218: --
219: cursor c_unique_PRB(l_table_alias varchar2) is
220: select distinct cpe.information1,
221: cpe.information2,

Line 230: -- and tr.where_clause = l_BEN_PL_REGY_BOD_F

226: from ben_copy_entity_results cpe,
227: pqh_table_route tr
228: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
229: and cpe.table_route_id = tr.table_route_id
230: -- and tr.where_clause = l_BEN_PL_REGY_BOD_F
231: and tr.table_alias = l_table_alias
232: and cpe.number_of_copies = 1 --ADDITION
233: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
234: order by information1, information2; --added for bug: 5151945

Line 268: from BEN_PL_REGY_BOD_F PRB

264: c_business_group_id number,
265: c_new_pk_id number) is
266: select
267: PRB.pl_regy_bod_id new_value
268: from BEN_PL_REGY_BOD_F PRB
269: where
270: nvl(PRB.PL_ID,-999) = nvl(l_PL_ID,-999) and
271: nvl(PRB.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and
272: PRB.regy_pl_name = l_regy_pl_name and

Line 281: from BEN_PL_REGY_BOD_F PRB1

277: and effective_end_date ;
278: --END TEMPIK
279: /*TEMPIK
280: and exists ( select null
281: from BEN_PL_REGY_BOD_F PRB1
282: where
283: nvl(PRB1.PL_ID,-999) = nvl(l_PL_ID,-999) and
284: nvl(PRB1.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and
285: PRB1.regy_pl_name = l_regy_pl_name and

Line 289: from BEN_PL_REGY_BOD_F PRB2

285: PRB1.regy_pl_name = l_regy_pl_name and
286: PRB1.business_group_id = c_business_group_id
287: and PRB1.effective_start_date <= c_effective_start_date )
288: and exists ( select null
289: from BEN_PL_REGY_BOD_F PRB2
290: where
291: nvl(PRB2.PL_ID,-999) = nvl(l_PL_ID,-999) and
292: nvl(PRB2.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and
293: PRB2.regy_pl_name = l_regy_pl_name and

Line 436: (p_base_table_name => 'BEN_PL_REGY_BOD_F',

432: if c_find_PRB_in_target%found then
433: --
434: --TEMPIK
435: l_dt_rec_found := dt_api.check_min_max_dates
436: (p_base_table_name => 'BEN_PL_REGY_BOD_F',
437: p_base_key_column => 'PL_REGY_BOD_ID',
438: p_base_key_value => l_new_value,
439: p_from_date => l_min_esd,
440: p_to_date => l_max_eed );

Line 495: hr_utility.set_location(' BEN_PL_REGY_BOD_F CREATE_PLAN_REGULATORY_BODY ',20);

491: end if;
492:
493: if l_first_rec and not l_update then
494: -- Call Create routine.
495: hr_utility.set_location(' BEN_PL_REGY_BOD_F CREATE_PLAN_REGULATORY_BODY ',20);
496: BEN_PLAN_REGULATORY_BODY_API.CREATE_PLAN_REGULATORY_BODY(
497: --
498: P_VALIDATE => false
499: ,P_EFFECTIVE_DATE => l_effective_date

Line 564: hr_utility.set_location(' BEN_PL_REGY_BOD_F UPDATE_PLAN_REGULATORY_BODY ',30);

560: else
561: --
562: -- Call Update routine for the pk_id created in prev run .
563: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
564: hr_utility.set_location(' BEN_PL_REGY_BOD_F UPDATE_PLAN_REGULATORY_BODY ',30);
565: --UPD START
566: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
567: --
568: if l_update then