APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 8860: -- and tr.where_clause = l_BEN_BNFT_POOL_RLOVR_RQMT_F

8856: from ben_copy_entity_results cpe,
8857: pqh_table_route tr
8858: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8859: and cpe.table_route_id = tr.table_route_id
8860: -- and tr.where_clause = l_BEN_BNFT_POOL_RLOVR_RQMT_F
8861: and tr.table_alias = l_table_alias
8862: and cpe.number_of_copies = 1 -- ADDITION
8863: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8864: order by information1, information2; --added for bug: 5151945

Line 8898: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR

8894: c_business_group_id number,
8895: c_new_pk_id number) is
8896: select
8897: BPR.bnft_pool_rlovr_rqmt_id new_value
8898: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR
8899: where
8900: BPR.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
8901: BPR.BNFT_PRVDR_POOL_ID = l_BNFT_PRVDR_POOL_ID and
8902: BPR.business_group_id = c_business_group_id

Line 8910: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR1

8906: and effective_end_date ;
8907: --END TEMPIK
8908: /*TEMPIK
8909: and exists ( select null
8910: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR1
8911: where
8912: BPR1.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
8913: BPR1.BNFT_PRVDR_POOL_ID = l_BNFT_PRVDR_POOL_ID and
8914: BPR1.business_group_id = c_business_group_id

Line 8917: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR2

8913: BPR1.BNFT_PRVDR_POOL_ID = l_BNFT_PRVDR_POOL_ID and
8914: BPR1.business_group_id = c_business_group_id
8915: and BPR1.effective_start_date <= c_effective_start_date )
8916: and exists ( select null
8917: from BEN_BNFT_POOL_RLOVR_RQMT_F BPR2
8918: where
8919: BPR2.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
8920: BPR2.BNFT_PRVDR_POOL_ID = l_BNFT_PRVDR_POOL_ID and
8921: BPR2.business_group_id = c_business_group_id

Line 9071: (p_base_table_name => 'BEN_BNFT_POOL_RLOVR_RQMT_F',

9067: if c_find_BPR_in_target%found then
9068: --
9069: --TEMPIK
9070: l_dt_rec_found := dt_api.check_min_max_dates
9071: (p_base_table_name => 'BEN_BNFT_POOL_RLOVR_RQMT_F',
9072: p_base_key_column => 'BNFT_POOL_RLOVR_RQMT_ID',
9073: p_base_key_value => l_new_value,
9074: p_from_date => l_min_esd,
9075: p_to_date => l_max_eed );

Line 9136: hr_utility.set_location(' BEN_BNFT_POOL_RLOVR_RQMT_F CREATE_BNFT_POOL_RLOVR_RQMT ',20);

9132: if l_first_rec and not l_update then
9133: -- UPD END
9134:
9135: -- Call Create routine.
9136: hr_utility.set_location(' BEN_BNFT_POOL_RLOVR_RQMT_F CREATE_BNFT_POOL_RLOVR_RQMT ',20);
9137: BEN_BNFT_POOL_RLOVR_RQMT_API.CREATE_BNFT_POOL_RLOVR_RQMT(
9138: --
9139: P_VALIDATE => false
9140: ,P_EFFECTIVE_DATE => l_effective_date

Line 9220: hr_utility.set_location(' BEN_BNFT_POOL_RLOVR_RQMT_F UPDATE_BNFT_POOL_RLOVR_RQMT ',30);

9216: else
9217: --
9218: -- Call Update routine for the pk_id created in prev run .
9219: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
9220: hr_utility.set_location(' BEN_BNFT_POOL_RLOVR_RQMT_F UPDATE_BNFT_POOL_RLOVR_RQMT ',30);
9221: --UPD START
9222: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
9223: --
9224: if l_update then