APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_MTCHG_RT_F

Line 361: -- START OF BEN_MTCHG_RT_F ----------------------

357: ---------------------------------------------------------------
358: -- END OF BEN_ACTY_VRBL_RT_F ----------------------
359: ---------------------------------------------------------------
360: ---------------------------------------------------------------
361: -- START OF BEN_MTCHG_RT_F ----------------------
362: ---------------------------------------------------------------
363: cursor c_mtr_from_parent(c_ACTY_BASE_RT_ID number) is
364: select mtchg_rt_id
365: from BEN_MTCHG_RT_F

Line 365: from BEN_MTCHG_RT_F

361: -- START OF BEN_MTCHG_RT_F ----------------------
362: ---------------------------------------------------------------
363: cursor c_mtr_from_parent(c_ACTY_BASE_RT_ID number) is
364: select mtchg_rt_id
365: from BEN_MTCHG_RT_F
366: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
367: --
368: cursor c_mtr(c_mtchg_rt_id number,c_mirror_src_entity_result_id number,
369: c_table_alias varchar2 ) is

Line 371: from BEN_MTCHG_RT_F mtr

367: --
368: cursor c_mtr(c_mtchg_rt_id number,c_mirror_src_entity_result_id number,
369: c_table_alias varchar2 ) is
370: select mtr.*
371: from BEN_MTCHG_RT_F mtr
372: where mtr.mtchg_rt_id = c_mtchg_rt_id
373: -- and mtr.business_group_id = p_business_group_id
374: and not exists (
375: select /* */ null

Line 382: -- and trt.where_clause = 'BEN_MTCHG_RT_F'

378: where copy_entity_txn_id = p_copy_entity_txn_id
379: -- and trt.table_route_id = cpe.table_route_id
380: and ( -- c_mirror_src_entity_result_id is null or
381: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
382: -- and trt.where_clause = 'BEN_MTCHG_RT_F'
383: and cpe.table_alias = c_table_alias
384: and information1 = c_mtchg_rt_id
385: -- and information4 = mtr.business_group_id
386: and information2 = mtr.effective_start_date

Line 391: -- END OF BEN_MTCHG_RT_F ----------------------

387: and information3 = mtr.effective_end_date);
388: l_mtchg_rt_id number(15);
389: l_out_mtr_result_id number(15);
390: ---------------------------------------------------------------
391: -- END OF BEN_MTCHG_RT_F ----------------------
392: ---------------------------------------------------------------
393: ---------------------------------------------------------------
394: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
395: ---------------------------------------------------------------

Line 1907: -- START OF BEN_MTCHG_RT_F ----------------------

1903: ---------------------------------------------------------------
1904: -- END OF BEN_ACTY_VRBL_RT_F ----------------------
1905: ---------------------------------------------------------------
1906: ---------------------------------------------------------------
1907: -- START OF BEN_MTCHG_RT_F ----------------------
1908: ---------------------------------------------------------------
1909: --
1910: for l_parent_rec in c_mtr_from_parent(l_ACTY_BASE_RT_ID) loop
1911: --

Line 2063: -- END OF BEN_MTCHG_RT_F ----------------------

2059: end loop;
2060: --
2061: end loop;
2062: ---------------------------------------------------------------
2063: -- END OF BEN_MTCHG_RT_F ----------------------
2064: ---------------------------------------------------------------
2065: ---------------------------------------------------------------
2066: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
2067: ---------------------------------------------------------------