APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PYRL_PRTE_F

Line 2859: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------

2855: ---------------------------------------------------------------
2856: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
2857: ---------------------------------------------------------------
2858: ---------------------------------------------------------------
2859: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
2860: ---------------------------------------------------------------
2861: cursor c_epy_from_parent(c_ELIGY_PRFL_ID number) is
2862: select elig_pyrl_prte_id
2863: from BEN_ELIG_PYRL_PRTE_F

Line 2863: from BEN_ELIG_PYRL_PRTE_F

2859: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
2860: ---------------------------------------------------------------
2861: cursor c_epy_from_parent(c_ELIGY_PRFL_ID number) is
2862: select elig_pyrl_prte_id
2863: from BEN_ELIG_PYRL_PRTE_F
2864: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2865: --
2866: cursor c_epy(c_elig_pyrl_prte_id number,c_mirror_src_entity_result_id number ,
2867: c_table_alias varchar2 ) is

Line 2869: from BEN_ELIG_PYRL_PRTE_F epy

2865: --
2866: cursor c_epy(c_elig_pyrl_prte_id number,c_mirror_src_entity_result_id number ,
2867: c_table_alias varchar2 ) is
2868: select epy.*
2869: from BEN_ELIG_PYRL_PRTE_F epy
2870: where epy.elig_pyrl_prte_id = c_elig_pyrl_prte_id
2871: -- and epy.business_group_id = p_business_group_id
2872: and not exists (
2873: select /* */ null

Line 2880: -- and trt.where_clause = 'BEN_ELIG_PYRL_PRTE_F'

2876: where copy_entity_txn_id = p_copy_entity_txn_id
2877: -- and trt.table_route_id = cpe.table_route_id
2878: and ( -- c_mirror_src_entity_result_id is null or
2879: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2880: -- and trt.where_clause = 'BEN_ELIG_PYRL_PRTE_F'
2881: and cpe.table_alias = c_table_alias
2882: and information1 = c_elig_pyrl_prte_id
2883: -- and information4 = epy.business_group_id
2884: and information2 = epy.effective_start_date

Line 2905: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------

2901: where payroll_id = c_payroll_id;
2902:
2903: l_payroll_start_date pay_all_payrolls_f.effective_start_date%type;
2904: ---------------------------------------------------------------
2905: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------
2906: ---------------------------------------------------------------
2907: ---------------------------------------------------------------
2908: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
2909: ---------------------------------------------------------------

Line 9038: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------

9034: ---------------------------------------------------------------
9035: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
9036: ---------------------------------------------------------------
9037: ---------------------------------------------------------------
9038: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
9039: ---------------------------------------------------------------
9040: --
9041: for l_parent_rec in c_epy_from_parent(l_ELIGY_PRFL_ID) loop
9042: --

Line 9183: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------

9179: end loop;
9180: --
9181: end loop;
9182: ---------------------------------------------------------------
9183: -- END OF BEN_ELIG_PYRL_PRTE_F ----------------------
9184: ---------------------------------------------------------------
9185: ---------------------------------------------------------------
9186: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
9187: ---------------------------------------------------------------