APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PY_BSS_PRTE_F

Line 2908: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------

2904: ---------------------------------------------------------------
2905: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------
2906: ---------------------------------------------------------------
2907: ---------------------------------------------------------------
2908: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
2909: ---------------------------------------------------------------
2910: cursor c_epb_from_parent(c_ELIGY_PRFL_ID number) is
2911: select elig_py_bss_prte_id
2912: from BEN_ELIG_PY_BSS_PRTE_F

Line 2912: from BEN_ELIG_PY_BSS_PRTE_F

2908: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
2909: ---------------------------------------------------------------
2910: cursor c_epb_from_parent(c_ELIGY_PRFL_ID number) is
2911: select elig_py_bss_prte_id
2912: from BEN_ELIG_PY_BSS_PRTE_F
2913: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2914: --
2915: cursor c_epb(c_elig_py_bss_prte_id number,c_mirror_src_entity_result_id number ,
2916: c_table_alias varchar2 ) is

Line 2918: from BEN_ELIG_PY_BSS_PRTE_F epb

2914: --
2915: cursor c_epb(c_elig_py_bss_prte_id number,c_mirror_src_entity_result_id number ,
2916: c_table_alias varchar2 ) is
2917: select epb.*
2918: from BEN_ELIG_PY_BSS_PRTE_F epb
2919: where epb.elig_py_bss_prte_id = c_elig_py_bss_prte_id
2920: -- and epb.business_group_id = p_business_group_id
2921: and not exists (
2922: select /* */ null

Line 2929: -- and trt.where_clause = 'BEN_ELIG_PY_BSS_PRTE_F'

2925: where copy_entity_txn_id = p_copy_entity_txn_id
2926: -- and trt.table_route_id = cpe.table_route_id
2927: and ( -- c_mirror_src_entity_result_id is null or
2928: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2929: -- and trt.where_clause = 'BEN_ELIG_PY_BSS_PRTE_F'
2930: and cpe.table_alias = c_table_alias
2931: and information1 = c_elig_py_bss_prte_id
2932: -- and information4 = epb.business_group_id
2933: and information2 = epb.effective_start_date

Line 2946: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------

2942: select name from per_pay_bases
2943: where business_group_id = p_business_group_id
2944: and pay_basis_id = p_id;
2945: ---------------------------------------------------------------
2946: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
2947: ---------------------------------------------------------------
2948: ---------------------------------------------------------------
2949: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
2950: ---------------------------------------------------------------

Line 9186: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------

9182: ---------------------------------------------------------------
9183: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------
9184: ---------------------------------------------------------------
9185: ---------------------------------------------------------------
9186: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
9187: ---------------------------------------------------------------
9188: --
9189: for l_parent_rec in c_epb_from_parent(l_ELIGY_PRFL_ID) loop
9190: --

Line 9318: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------

9314: end loop;
9315: --
9316: end loop;
9317: ---------------------------------------------------------------
9318: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
9319: ---------------------------------------------------------------
9320: ---------------------------------------------------------------
9321: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
9322: ---------------------------------------------------------------