DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ORG_UNIT_RT_F

Line 6521: -- START OF BEN_ORG_UNIT_RT_F ----------------------

6517: ---------------------------------------------------------------
6518: -- END OF BEN_LVG_RSN_RT_F ----------------------
6519: ---------------------------------------------------------------
6520: ---------------------------------------------------------------
6521: -- START OF BEN_ORG_UNIT_RT_F ----------------------
6522: ---------------------------------------------------------------
6523: cursor c_our_from_parent(c_VRBL_RT_PRFL_ID number) is
6524: select org_unit_rt_id
6525: from BEN_ORG_UNIT_RT_F

Line 6525: from BEN_ORG_UNIT_RT_F

6521: -- START OF BEN_ORG_UNIT_RT_F ----------------------
6522: ---------------------------------------------------------------
6523: cursor c_our_from_parent(c_VRBL_RT_PRFL_ID number) is
6524: select org_unit_rt_id
6525: from BEN_ORG_UNIT_RT_F
6526: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6527: --
6528: cursor c_our(c_org_unit_rt_id number,c_mirror_src_entity_result_id number,
6529: c_table_alias varchar2 ) is

Line 6531: from BEN_ORG_UNIT_RT_F our

6527: --
6528: cursor c_our(c_org_unit_rt_id number,c_mirror_src_entity_result_id number,
6529: c_table_alias varchar2 ) is
6530: select our.*
6531: from BEN_ORG_UNIT_RT_F our
6532: where our.org_unit_rt_id = c_org_unit_rt_id
6533: -- and our.business_group_id = p_business_group_id
6534: and not exists (
6535: select /* */ null

Line 6542: -- and trt.where_clause = 'BEN_ORG_UNIT_RT_F'

6538: where copy_entity_txn_id = p_copy_entity_txn_id
6539: -- and trt.table_route_id = cpe.table_route_id
6540: and ( -- c_mirror_src_entity_result_id is null or
6541: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6542: -- and trt.where_clause = 'BEN_ORG_UNIT_RT_F'
6543: and cpe.table_alias = c_table_alias
6544: and information1 = c_org_unit_rt_id
6545: -- and information4 = our.business_group_id
6546: and information2 = our.effective_start_date

Line 6566: -- END OF BEN_ORG_UNIT_RT_F ----------------------

6562: --
6563: l_org_unit_rt_id number(15);
6564: l_out_our_result_id number(15);
6565: ---------------------------------------------------------------
6566: -- END OF BEN_ORG_UNIT_RT_F ----------------------
6567: ---------------------------------------------------------------
6568: ---------------------------------------------------------------
6569: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
6570: ---------------------------------------------------------------

Line 10509: -- START OF BEN_ORG_UNIT_RT_F ----------------------

10505: ---------------------------------------------------------------
10506: -- END OF BEN_LVG_RSN_RT_F ----------------------
10507: ---------------------------------------------------------------
10508: ---------------------------------------------------------------
10509: -- START OF BEN_ORG_UNIT_RT_F ----------------------
10510: ---------------------------------------------------------------
10511: --
10512: hr_utility.set_location('START OF BEN_ORG_UNIT_RT_F',100);
10513: for l_parent_rec in c_our_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 10512: hr_utility.set_location('START OF BEN_ORG_UNIT_RT_F',100);

10508: ---------------------------------------------------------------
10509: -- START OF BEN_ORG_UNIT_RT_F ----------------------
10510: ---------------------------------------------------------------
10511: --
10512: hr_utility.set_location('START OF BEN_ORG_UNIT_RT_F',100);
10513: for l_parent_rec in c_our_from_parent(l_VRBL_RT_PRFL_ID) loop
10514: --
10515: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
10516:

Line 10653: hr_utility.set_location('END OF BEN_ORG_UNIT_RT_F',100);

10649: --
10650: end loop;
10651: --
10652: end loop;
10653: hr_utility.set_location('END OF BEN_ORG_UNIT_RT_F',100);
10654: ---------------------------------------------------------------
10655: -- END OF BEN_ORG_UNIT_RT_F ----------------------
10656: ---------------------------------------------------------------
10657: ---------------------------------------------------------------

Line 10655: -- END OF BEN_ORG_UNIT_RT_F ----------------------

10651: --
10652: end loop;
10653: hr_utility.set_location('END OF BEN_ORG_UNIT_RT_F',100);
10654: ---------------------------------------------------------------
10655: -- END OF BEN_ORG_UNIT_RT_F ----------------------
10656: ---------------------------------------------------------------
10657: ---------------------------------------------------------------
10658: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
10659: ---------------------------------------------------------------