APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 24293: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP

24289: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24290: pqh_table_route tr
24291: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24292: and cpe.table_route_id = tr.table_route_id
24293: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24294: and tr.table_alias = l_table_alias
24295: and cpe.number_of_copies = 1 -- ADDITION
24296: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24297: order by information1, information2; --added for bug: 5151945

Line 24329: from BEN_DSGN_RQMT_RLSHP_TYP DRR

24325: c_business_group_id number,
24326: c_new_pk_id number) is
24327: select
24328: DRR.dsgn_rqmt_rlshp_typ_id new_value
24329: from BEN_DSGN_RQMT_RLSHP_TYP DRR
24330: where
24331: DRR.DSGN_RQMT_ID = l_DSGN_RQMT_ID and
24332: DRR.rlshp_typ_cd = l_rlshp_typ_cd and
24333: DRR.business_group_id = c_business_group_id

Line 24498: hr_utility.set_location(' BEN_DSGN_RQMT_RLSHP_TYP CREATE_DSGN_RQMT_RLSHP_TYP ',20);

24494: end if;
24495: --
24496: if l_first_rec and not l_update then
24497: -- Call Create routine.
24498: hr_utility.set_location(' BEN_DSGN_RQMT_RLSHP_TYP CREATE_DSGN_RQMT_RLSHP_TYP ',20);
24499: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(
24500: --
24501: P_VALIDATE => false
24502: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

Line 24499: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(

24495: --
24496: if l_first_rec and not l_update then
24497: -- Call Create routine.
24498: hr_utility.set_location(' BEN_DSGN_RQMT_RLSHP_TYP CREATE_DSGN_RQMT_RLSHP_TYP ',20);
24499: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(
24500: --
24501: P_VALIDATE => false
24502: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
24503: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 24558: BEN_DSGN_RQMT_RLSHP_TYP_API.UPDATE_DSGN_RQMT_RLSHP_TYP(

24554: --
24555: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
24556: --
24557: elsif l_update then
24558: BEN_DSGN_RQMT_RLSHP_TYP_API.UPDATE_DSGN_RQMT_RLSHP_TYP(
24559: --
24560: P_VALIDATE => false
24561: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
24562: ,P_BUSINESS_GROUP_ID => p_target_business_group_id