APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PY_BSS_RT_F

Line 6828: -- START OF BEN_PY_BSS_RT_F ----------------------

6824: ---------------------------------------------------------------
6825: -- END OF BEN_PYRL_RT_F ----------------------
6826: ---------------------------------------------------------------
6827: ---------------------------------------------------------------
6828: -- START OF BEN_PY_BSS_RT_F ----------------------
6829: ---------------------------------------------------------------
6830: cursor c_pbr_from_parent(c_VRBL_RT_PRFL_ID number) is
6831: select py_bss_rt_id
6832: from BEN_PY_BSS_RT_F

Line 6832: from BEN_PY_BSS_RT_F

6828: -- START OF BEN_PY_BSS_RT_F ----------------------
6829: ---------------------------------------------------------------
6830: cursor c_pbr_from_parent(c_VRBL_RT_PRFL_ID number) is
6831: select py_bss_rt_id
6832: from BEN_PY_BSS_RT_F
6833: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6834: --
6835: cursor c_pbr(c_py_bss_rt_id number,c_mirror_src_entity_result_id number,
6836: c_table_alias varchar2 ) is

Line 6838: from BEN_PY_BSS_RT_F pbr

6834: --
6835: cursor c_pbr(c_py_bss_rt_id number,c_mirror_src_entity_result_id number,
6836: c_table_alias varchar2 ) is
6837: select pbr.*
6838: from BEN_PY_BSS_RT_F pbr
6839: where pbr.py_bss_rt_id = c_py_bss_rt_id
6840: -- and pbr.business_group_id = p_business_group_id
6841: and not exists (
6842: select /* */ null

Line 6849: -- and trt.where_clause = 'BEN_PY_BSS_RT_F'

6845: where copy_entity_txn_id = p_copy_entity_txn_id
6846: -- and trt.table_route_id = cpe.table_route_id
6847: and ( -- c_mirror_src_entity_result_id is null or
6848: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6849: -- and trt.where_clause = 'BEN_PY_BSS_RT_F'
6850: and cpe.table_alias = c_table_alias
6851: and information1 = c_py_bss_rt_id
6852: -- and information4 = pbr.business_group_id
6853: and information2 = pbr.effective_start_date

Line 6866: -- END OF BEN_PY_BSS_RT_F ----------------------

6862:
6863: l_py_bss_rt_id number(15);
6864: l_out_pbr_result_id number(15);
6865: ---------------------------------------------------------------
6866: -- END OF BEN_PY_BSS_RT_F ----------------------
6867: ---------------------------------------------------------------
6868: ---------------------------------------------------------------
6869: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
6870: ---------------------------------------------------------------

Line 11419: -- START OF BEN_PY_BSS_RT_F ----------------------

11415: ---------------------------------------------------------------
11416: -- END OF BEN_PYRL_RT_F ----------------------
11417: ---------------------------------------------------------------
11418: ---------------------------------------------------------------
11419: -- START OF BEN_PY_BSS_RT_F ----------------------
11420: ---------------------------------------------------------------
11421: --
11422: hr_utility.set_location('START OF BEN_PY_BSS_RT_F ',100);
11423: for l_parent_rec in c_pbr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 11422: hr_utility.set_location('START OF BEN_PY_BSS_RT_F ',100);

11418: ---------------------------------------------------------------
11419: -- START OF BEN_PY_BSS_RT_F ----------------------
11420: ---------------------------------------------------------------
11421: --
11422: hr_utility.set_location('START OF BEN_PY_BSS_RT_F ',100);
11423: for l_parent_rec in c_pbr_from_parent(l_VRBL_RT_PRFL_ID) loop
11424: --
11425: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
11426:

Line 11553: hr_utility.set_location('END OF BEN_PY_BSS_RT_F ',100);

11549: --
11550: end loop;
11551: --
11552: end loop;
11553: hr_utility.set_location('END OF BEN_PY_BSS_RT_F ',100);
11554: ---------------------------------------------------------------
11555: -- END OF BEN_PY_BSS_RT_F ----------------------
11556: ---------------------------------------------------------------
11557: ---------------------------------------------------------------

Line 11555: -- END OF BEN_PY_BSS_RT_F ----------------------

11551: --
11552: end loop;
11553: hr_utility.set_location('END OF BEN_PY_BSS_RT_F ',100);
11554: ---------------------------------------------------------------
11555: -- END OF BEN_PY_BSS_RT_F ----------------------
11556: ---------------------------------------------------------------
11557: ---------------------------------------------------------------
11558: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
11559: ---------------------------------------------------------------