eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 394: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

390: ---------------------------------------------------------------
391: -- END OF BEN_MTCHG_RT_F ----------------------
392: ---------------------------------------------------------------
393: ---------------------------------------------------------------
394: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
395: ---------------------------------------------------------------
396: cursor c_pmr_from_parent(c_ACTY_BASE_RT_ID number) is
397: select prtl_mo_rt_prtn_val_id
398: from BEN_PRTL_MO_RT_PRTN_VAL_F

Line 398: from BEN_PRTL_MO_RT_PRTN_VAL_F

394: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
395: ---------------------------------------------------------------
396: cursor c_pmr_from_parent(c_ACTY_BASE_RT_ID number) is
397: select prtl_mo_rt_prtn_val_id
398: from BEN_PRTL_MO_RT_PRTN_VAL_F
399: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
400: --
401: cursor c_pmr(c_prtl_mo_rt_prtn_val_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
402: select pmr.*

Line 403: from BEN_PRTL_MO_RT_PRTN_VAL_F pmr

399: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
400: --
401: cursor c_pmr(c_prtl_mo_rt_prtn_val_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
402: select pmr.*
403: from BEN_PRTL_MO_RT_PRTN_VAL_F pmr
404: where pmr.prtl_mo_rt_prtn_val_id = c_prtl_mo_rt_prtn_val_id
405: -- and pmr.business_group_id = p_business_group_id
406: and not exists (
407: select /* */ null

Line 414: -- and trt.where_clause = 'BEN_PRTL_MO_RT_PRTN_VAL_F'

410: where copy_entity_txn_id = p_copy_entity_txn_id
411: -- and trt.table_route_id = cpe.table_route_id
412: and ( -- c_mirror_src_entity_result_id is null or
413: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
414: -- and trt.where_clause = 'BEN_PRTL_MO_RT_PRTN_VAL_F'
415: and cpe.table_alias = c_table_alias
416: and information1 = c_prtl_mo_rt_prtn_val_id
417: -- and information4 = pmr.business_group_id
418: and information2 = pmr.effective_start_date

Line 423: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

419: and information3 = pmr.effective_end_date);
420: l_prtl_mo_rt_prtn_val_id number(15);
421: l_out_pmr_result_id number(15);
422: ---------------------------------------------------------------
423: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
424: ---------------------------------------------------------------
425: ---------------------------------------------------------------
426: -- START OF BEN_PTD_LMT_F ----------------------
427: ---------------------------------------------------------------

Line 2066: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

2062: ---------------------------------------------------------------
2063: -- END OF BEN_MTCHG_RT_F ----------------------
2064: ---------------------------------------------------------------
2065: ---------------------------------------------------------------
2066: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
2067: ---------------------------------------------------------------
2068: --
2069: for l_parent_rec in c_pmr_from_parent(l_ACTY_BASE_RT_ID) loop
2070: --

Line 2226: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

2222: end loop;
2223: --
2224: end loop;
2225: ---------------------------------------------------------------
2226: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
2227: ---------------------------------------------------------------
2228: ---------------------------------------------------------------
2229: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
2230: ---------------------------------------------------------------

Line 3188: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

3184: ---------------------------------------------------------------
3185: -- END OF BEN_ACTL_PREM_F ----------------------
3186: ---------------------------------------------------------------
3187: ---------------------------------------------------------------
3188: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3189: ---------------------------------------------------------------
3190: cursor c_pmr_from_parent(c_ACTL_PREM_ID number) is
3191: select prtl_mo_rt_prtn_val_id
3192: from BEN_PRTL_MO_RT_PRTN_VAL_F

Line 3192: from BEN_PRTL_MO_RT_PRTN_VAL_F

3188: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3189: ---------------------------------------------------------------
3190: cursor c_pmr_from_parent(c_ACTL_PREM_ID number) is
3191: select prtl_mo_rt_prtn_val_id
3192: from BEN_PRTL_MO_RT_PRTN_VAL_F
3193: where ACTL_PREM_ID = c_ACTL_PREM_ID;
3194: --
3195: cursor c_pmr(c_prtl_mo_rt_prtn_val_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3196: select pmr.*

Line 3197: from BEN_PRTL_MO_RT_PRTN_VAL_F pmr

3193: where ACTL_PREM_ID = c_ACTL_PREM_ID;
3194: --
3195: cursor c_pmr(c_prtl_mo_rt_prtn_val_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3196: select pmr.*
3197: from BEN_PRTL_MO_RT_PRTN_VAL_F pmr
3198: where pmr.prtl_mo_rt_prtn_val_id = c_prtl_mo_rt_prtn_val_id
3199: -- and pmr.business_group_id = p_business_group_id
3200: and not exists (
3201: select /* */ null

Line 3208: -- and trt.where_clause = 'BEN_PRTL_MO_RT_PRTN_VAL_F'

3204: where copy_entity_txn_id = p_copy_entity_txn_id
3205: -- and trt.table_route_id = cpe.table_route_id
3206: and ( -- c_mirror_src_entity_result_id is null or
3207: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3208: -- and trt.where_clause = 'BEN_PRTL_MO_RT_PRTN_VAL_F'
3209: and cpe.table_alias = c_table_alias
3210: and information1 = c_prtl_mo_rt_prtn_val_id
3211: -- and information4 = pmr.business_group_id
3212: and information2 = pmr.effective_start_date

Line 3217: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

3213: and information3 = pmr.effective_end_date);
3214: l_prtl_mo_rt_prtn_val_id number(15);
3215: l_out_pmr_result_id number(15);
3216: ---------------------------------------------------------------
3217: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3218: ---------------------------------------------------------------
3219: ---------------------------------------------------------------
3220: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3221: ---------------------------------------------------------------

Line 3577: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

3573: end loop;
3574: --
3575:
3576: ---------------------------------------------------------------
3577: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3578: ---------------------------------------------------------------
3579: --
3580: for l_parent_rec in c_pmr_from_parent(l_ACTL_PREM_ID) loop
3581: --

Line 3738: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------

3734: end loop;
3735: --
3736: end loop;
3737: ---------------------------------------------------------------
3738: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
3739: ---------------------------------------------------------------
3740: ---------------------------------------------------------------
3741: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
3742: ---------------------------------------------------------------