APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 24191: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP

24187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24188: pqh_table_route tr
24189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24190: and cpe.table_route_id = tr.table_route_id
24191: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24192: and tr.table_alias = l_table_alias
24193: and cpe.number_of_copies = 1 -- ADDITION
24194: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
24195: order by information1, information2; --added for bug: 5151945

Line 24227: from BEN_DSGN_RQMT_RLSHP_TYP DRR

24223: c_business_group_id number,
24224: c_new_pk_id number) is
24225: select
24226: DRR.dsgn_rqmt_rlshp_typ_id new_value
24227: from BEN_DSGN_RQMT_RLSHP_TYP DRR
24228: where
24229: DRR.DSGN_RQMT_ID = l_DSGN_RQMT_ID and
24230: DRR.rlshp_typ_cd = l_rlshp_typ_cd and
24231: DRR.business_group_id = c_business_group_id

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

24392: end if;
24393: --
24394: if l_first_rec and not l_update then
24395: -- Call Create routine.
24396: hr_utility.set_location(' BEN_DSGN_RQMT_RLSHP_TYP CREATE_DSGN_RQMT_RLSHP_TYP ',20);
24397: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(
24398: --
24399: P_VALIDATE => false
24400: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

Line 24397: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(

24393: --
24394: if l_first_rec and not l_update then
24395: -- Call Create routine.
24396: hr_utility.set_location(' BEN_DSGN_RQMT_RLSHP_TYP CREATE_DSGN_RQMT_RLSHP_TYP ',20);
24397: BEN_DSGN_RQMT_RLSHP_TYP_API.CREATE_DSGN_RQMT_RLSHP_TYP(
24398: --
24399: P_VALIDATE => false
24400: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
24401: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 24456: BEN_DSGN_RQMT_RLSHP_TYP_API.UPDATE_DSGN_RQMT_RLSHP_TYP(

24452: --
24453: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
24454: --
24455: elsif l_update then
24456: BEN_DSGN_RQMT_RLSHP_TYP_API.UPDATE_DSGN_RQMT_RLSHP_TYP(
24457: --
24458: P_VALIDATE => false
24459: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
24460: ,P_BUSINESS_GROUP_ID => p_target_business_group_id