DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PCT_FL_TM_RT_F

Line 6569: -- START OF BEN_PCT_FL_TM_RT_F ----------------------

6565: ---------------------------------------------------------------
6566: -- END OF BEN_ORG_UNIT_RT_F ----------------------
6567: ---------------------------------------------------------------
6568: ---------------------------------------------------------------
6569: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
6570: ---------------------------------------------------------------
6571: cursor c_pfr_from_parent(c_VRBL_RT_PRFL_ID number) is
6572: select distinct pct_fl_tm_rt_id
6573: from BEN_PCT_FL_TM_RT_F

Line 6573: from BEN_PCT_FL_TM_RT_F

6569: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
6570: ---------------------------------------------------------------
6571: cursor c_pfr_from_parent(c_VRBL_RT_PRFL_ID number) is
6572: select distinct pct_fl_tm_rt_id
6573: from BEN_PCT_FL_TM_RT_F
6574: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6575: --
6576: cursor c_pfr(c_pct_fl_tm_rt_id number,c_mirror_src_entity_result_id number,
6577: c_table_alias varchar2 ) is

Line 6579: from BEN_PCT_FL_TM_RT_F pfr

6575: --
6576: cursor c_pfr(c_pct_fl_tm_rt_id number,c_mirror_src_entity_result_id number,
6577: c_table_alias varchar2 ) is
6578: select pfr.*
6579: from BEN_PCT_FL_TM_RT_F pfr
6580: where pfr.pct_fl_tm_rt_id = c_pct_fl_tm_rt_id
6581: -- and pfr.business_group_id = p_business_group_id
6582: and not exists (
6583: select /* */ null

Line 6590: -- and trt.where_clause = 'BEN_PCT_FL_TM_RT_F'

6586: where copy_entity_txn_id = p_copy_entity_txn_id
6587: -- and trt.table_route_id = cpe.table_route_id
6588: and ( -- c_mirror_src_entity_result_id is null or
6589: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6590: -- and trt.where_clause = 'BEN_PCT_FL_TM_RT_F'
6591: and cpe.table_alias = c_table_alias
6592: and information1 = c_pct_fl_tm_rt_id
6593: -- and information4 = pfr.business_group_id
6594: and information2 = pfr.effective_start_date

Line 6606: -- and trt.where_clause = 'BEN_PCT_FL_TM_RT_F'

6602: -- pqh_table_route trt
6603: where copy_entity_txn_id = p_copy_entity_txn_id
6604: -- and trt.table_route_id = cpe.table_route_id
6605: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6606: -- and trt.where_clause = 'BEN_PCT_FL_TM_RT_F'
6607: and cpe.table_alias = c_table_alias
6608: and information1 = c_pct_fl_tm_rt_id
6609: -- and information4 = p_business_group_id
6610: ;

Line 6612: -- END OF BEN_PCT_FL_TM_RT_F ----------------------

6608: and information1 = c_pct_fl_tm_rt_id
6609: -- and information4 = p_business_group_id
6610: ;
6611: ---------------------------------------------------------------
6612: -- END OF BEN_PCT_FL_TM_RT_F ----------------------
6613: ---------------------------------------------------------------
6614: ---------------------------------------------------------------
6615: -- START OF BEN_PER_TYP_RT_F ----------------------
6616: ---------------------------------------------------------------

Line 10658: -- START OF BEN_PCT_FL_TM_RT_F ----------------------

10654: ---------------------------------------------------------------
10655: -- END OF BEN_ORG_UNIT_RT_F ----------------------
10656: ---------------------------------------------------------------
10657: ---------------------------------------------------------------
10658: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
10659: ---------------------------------------------------------------
10660: --
10661: for l_parent_rec in c_pfr_from_parent(l_VRBL_RT_PRFL_ID) loop
10662: --

Line 10776: -- END OF BEN_PCT_FL_TM_RT_F ----------------------

10772: );
10773: end loop;
10774: end loop;
10775: ---------------------------------------------------------------
10776: -- END OF BEN_PCT_FL_TM_RT_F ----------------------
10777: ---------------------------------------------------------------
10778: ---------------------------------------------------------------
10779: -- START OF BEN_PER_TYP_RT_F ----------------------
10780: ---------------------------------------------------------------