DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTY_RT_PTD_LMT_F

Line 282: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------

278: ---------------------------------------------------------------
279: -- END OF BEN_ACTL_PREM_F ----------------------
280: ---------------------------------------------------------------
281: ---------------------------------------------------------------
282: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------
283: ---------------------------------------------------------------
284: cursor c_apl_from_parent(c_ACTY_BASE_RT_ID number) is
285: select acty_rt_ptd_lmt_id
286: from BEN_ACTY_RT_PTD_LMT_F

Line 286: from BEN_ACTY_RT_PTD_LMT_F

282: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------
283: ---------------------------------------------------------------
284: cursor c_apl_from_parent(c_ACTY_BASE_RT_ID number) is
285: select acty_rt_ptd_lmt_id
286: from BEN_ACTY_RT_PTD_LMT_F
287: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
288: --
289: cursor c_apl(c_acty_rt_ptd_lmt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
290: select apl.*

Line 291: from BEN_ACTY_RT_PTD_LMT_F apl

287: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
288: --
289: cursor c_apl(c_acty_rt_ptd_lmt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
290: select apl.*
291: from BEN_ACTY_RT_PTD_LMT_F apl
292: where apl.acty_rt_ptd_lmt_id = c_acty_rt_ptd_lmt_id
293: -- and apl.business_group_id = p_business_group_id
294: and not exists (
295: select /* */ null

Line 302: -- and trt.where_clause = 'BEN_ACTY_RT_PTD_LMT_F'

298: where copy_entity_txn_id = p_copy_entity_txn_id
299: -- and trt.table_route_id = cpe.table_route_id
300: and ( -- c_mirror_src_entity_result_id is null or
301: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
302: -- and trt.where_clause = 'BEN_ACTY_RT_PTD_LMT_F'
303: and cpe.table_alias = c_table_alias
304: and information1 = c_acty_rt_ptd_lmt_id
305: -- and information4 = apl.business_group_id
306: and information2 = apl.effective_start_date

Line 311: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------

307: and information3 = apl.effective_end_date);
308: l_acty_rt_ptd_lmt_id number(15);
309: l_out_apl_result_id number(15);
310: ---------------------------------------------------------------
311: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------
312: ---------------------------------------------------------------
313: ---------------------------------------------------------------
314: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
315: ---------------------------------------------------------------

Line 430: from BEN_ACTY_RT_PTD_LMT_F

426: -- START OF BEN_PTD_LMT_F ----------------------
427: ---------------------------------------------------------------
428: cursor c_pdl_from_parent(c_ACTY_RT_PTD_LMT_ID number) is
429: select ptd_lmt_id
430: from BEN_ACTY_RT_PTD_LMT_F
431: where ACTY_RT_PTD_LMT_ID = c_ACTY_RT_PTD_LMT_ID ;
432: --
433: cursor c_pdl(c_ptd_lmt_id number,c_mirror_src_entity_result_id number,
434: c_table_alias varchar2 ) is

Line 1528: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------

1524: ** or Option to which they are attached - handled by create_premium_results call
1525: */
1526:
1527: ---------------------------------------------------------------
1528: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------
1529: ---------------------------------------------------------------
1530: --
1531: for l_parent_rec in c_apl_from_parent(l_ACTY_BASE_RT_ID) loop
1532: --

Line 1787: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------

1783: -- END OF BEN_PTD_LMT_F ----------------------
1784: ---------------------------------------------------------------
1785: end loop;
1786: ---------------------------------------------------------------
1787: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------
1788: ---------------------------------------------------------------
1789: ---------------------------------------------------------------
1790: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
1791: ---------------------------------------------------------------