DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_SCHEDD_HRS_RT_F

Line 6869: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------

6865: ---------------------------------------------------------------
6866: -- END OF BEN_PY_BSS_RT_F ----------------------
6867: ---------------------------------------------------------------
6868: ---------------------------------------------------------------
6869: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
6870: ---------------------------------------------------------------
6871: cursor c_shr_from_parent(c_VRBL_RT_PRFL_ID number) is
6872: select schedd_hrs_rt_id
6873: from BEN_SCHEDD_HRS_RT_F

Line 6873: from BEN_SCHEDD_HRS_RT_F

6869: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
6870: ---------------------------------------------------------------
6871: cursor c_shr_from_parent(c_VRBL_RT_PRFL_ID number) is
6872: select schedd_hrs_rt_id
6873: from BEN_SCHEDD_HRS_RT_F
6874: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6875: --
6876: cursor c_shr(c_schedd_hrs_rt_id number,c_mirror_src_entity_result_id number,
6877: c_table_alias varchar2 ) is

Line 6879: from BEN_SCHEDD_HRS_RT_F shr

6875: --
6876: cursor c_shr(c_schedd_hrs_rt_id number,c_mirror_src_entity_result_id number,
6877: c_table_alias varchar2 ) is
6878: select shr.*
6879: from BEN_SCHEDD_HRS_RT_F shr
6880: where shr.schedd_hrs_rt_id = c_schedd_hrs_rt_id
6881: -- and shr.business_group_id = p_business_group_id
6882: and not exists (
6883: select /* */ null

Line 6890: -- and trt.where_clause = 'BEN_SCHEDD_HRS_RT_F'

6886: where copy_entity_txn_id = p_copy_entity_txn_id
6887: -- and trt.table_route_id = cpe.table_route_id
6888: and ( -- c_mirror_src_entity_result_id is null or
6889: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6890: -- and trt.where_clause = 'BEN_SCHEDD_HRS_RT_F'
6891: and cpe.table_alias = c_table_alias
6892: and information1 = c_schedd_hrs_rt_id
6893: -- and information4 = shr.business_group_id
6894: and information2 = shr.effective_start_date

Line 6899: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------

6895: and information3 = shr.effective_end_date);
6896: l_schedd_hrs_rt_id number(15);
6897: l_out_shr_result_id number(15);
6898: ---------------------------------------------------------------
6899: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------
6900: ---------------------------------------------------------------
6901: ---------------------------------------------------------------
6902: -- START OF BEN_SVC_AREA_RT_F ----------------------
6903: ---------------------------------------------------------------

Line 11558: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------

11554: ---------------------------------------------------------------
11555: -- END OF BEN_PY_BSS_RT_F ----------------------
11556: ---------------------------------------------------------------
11557: ---------------------------------------------------------------
11558: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
11559: ---------------------------------------------------------------
11560: --
11561: for l_parent_rec in c_shr_from_parent(l_VRBL_RT_PRFL_ID) loop
11562: --

Line 11728: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------

11724: end loop;
11725: --
11726: end loop;
11727: ---------------------------------------------------------------
11728: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------
11729: ---------------------------------------------------------------
11730: ---------------------------------------------------------------
11731: -- START OF BEN_SVC_AREA_RT_F ----------------------
11732: ---------------------------------------------------------------