APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_QUA_IN_GR_PRTE_F

Line 3578: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------

3574: ---------------------------------------------------------------
3575: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
3576: ---------------------------------------------------------------
3577: ---------------------------------------------------------------
3578: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
3579: ---------------------------------------------------------------
3580: cursor c_eqg_from_parent(c_ELIGY_PRFL_ID number) is
3581: select elig_qua_in_gr_prte_id
3582: from BEN_ELIG_QUA_IN_GR_PRTE_F

Line 3582: from BEN_ELIG_QUA_IN_GR_PRTE_F

3578: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
3579: ---------------------------------------------------------------
3580: cursor c_eqg_from_parent(c_ELIGY_PRFL_ID number) is
3581: select elig_qua_in_gr_prte_id
3582: from BEN_ELIG_QUA_IN_GR_PRTE_F
3583: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3584: --
3585: cursor c_eqg(c_elig_qua_in_gr_prte_id number,c_mirror_src_entity_result_id number ,
3586: c_table_alias varchar2 ) is

Line 3588: from BEN_ELIG_QUA_IN_GR_PRTE_F eqg

3584: --
3585: cursor c_eqg(c_elig_qua_in_gr_prte_id number,c_mirror_src_entity_result_id number ,
3586: c_table_alias varchar2 ) is
3587: select eqg.*
3588: from BEN_ELIG_QUA_IN_GR_PRTE_F eqg
3589: where eqg.elig_qua_in_gr_prte_id = c_elig_qua_in_gr_prte_id
3590: -- and eqg.business_group_id = p_business_group_id
3591: and not exists (
3592: select /* */ null

Line 3599: -- and trt.where_clause = 'BEN_ELIG_QUA_IN_GR_PRTE_F'

3595: where copy_entity_txn_id = p_copy_entity_txn_id
3596: -- and trt.table_route_id = cpe.table_route_id
3597: and ( -- c_mirror_src_entity_result_id is null or
3598: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3599: -- and trt.where_clause = 'BEN_ELIG_QUA_IN_GR_PRTE_F'
3600: and cpe.table_alias = c_table_alias
3601: and information1 = c_elig_qua_in_gr_prte_id
3602: -- and information4 = eqg.business_group_id
3603: and information2 = eqg.effective_start_date

Line 3609: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------

3605: );
3606: l_elig_qua_in_gr_prte_id number(15);
3607: l_out_eqg_result_id number(15);
3608: ---------------------------------------------------------------
3609: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
3610: ---------------------------------------------------------------
3611: ---------------------------------------------------------------
3612: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
3613: ---------------------------------------------------------------

Line 11091: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------

11087: ---------------------------------------------------------------
11088: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
11089: ---------------------------------------------------------------
11090: ---------------------------------------------------------------
11091: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
11092: ---------------------------------------------------------------
11093: --
11094: for l_parent_rec in c_eqg_from_parent(l_ELIGY_PRFL_ID) loop
11095: --

Line 11193: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------

11189: end loop;
11190: --
11191: end loop;
11192: ---------------------------------------------------------------
11193: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
11194: ---------------------------------------------------------------
11195:
11196: ---------------------------------------------------------------
11197: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------