APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_COMPTNCY_PRTE_F

Line 3487: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------

3483: ---------------------------------------------------------------
3484: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
3485: ---------------------------------------------------------------
3486: ---------------------------------------------------------------
3487: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3488: ---------------------------------------------------------------
3489: cursor c_ecy_from_parent(c_ELIGY_PRFL_ID number) is
3490: select elig_comptncy_prte_id
3491: from BEN_ELIG_COMPTNCY_PRTE_F

Line 3491: from BEN_ELIG_COMPTNCY_PRTE_F

3487: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3488: ---------------------------------------------------------------
3489: cursor c_ecy_from_parent(c_ELIGY_PRFL_ID number) is
3490: select elig_comptncy_prte_id
3491: from BEN_ELIG_COMPTNCY_PRTE_F
3492: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3493: --
3494: cursor c_ecy(c_elig_comptncy_prte_id number,c_mirror_src_entity_result_id number ,
3495: c_table_alias varchar2 ) is

Line 3497: from BEN_ELIG_COMPTNCY_PRTE_F ecy

3493: --
3494: cursor c_ecy(c_elig_comptncy_prte_id number,c_mirror_src_entity_result_id number ,
3495: c_table_alias varchar2 ) is
3496: select ecy.*
3497: from BEN_ELIG_COMPTNCY_PRTE_F ecy
3498: where ecy.elig_comptncy_prte_id = c_elig_comptncy_prte_id
3499: -- and ecy.business_group_id = p_business_group_id
3500: and not exists (
3501: select /* */ null

Line 3508: -- and trt.where_clause = 'BEN_ELIG_COMPTNCY_PRTE_F'

3504: where copy_entity_txn_id = p_copy_entity_txn_id
3505: -- and trt.table_route_id = cpe.table_route_id
3506: and ( -- c_mirror_src_entity_result_id is null or
3507: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3508: -- and trt.where_clause = 'BEN_ELIG_COMPTNCY_PRTE_F'
3509: and cpe.table_alias = c_table_alias
3510: and information1 = c_elig_comptncy_prte_id
3511: -- and information4 = ecy.business_group_id
3512: and information2 = ecy.effective_start_date

Line 3540: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------

3536: where competence_id = c_competence_id;
3537:
3538: l_competence_start_date per_competences.date_from%type;
3539: ---------------------------------------------------------------
3540: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3541: ---------------------------------------------------------------
3542:
3543: ---------------------------------------------------------------
3544: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------

Line 7429: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------

7425: ---------------------------------------------------------------
7426: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
7427: ---------------------------------------------------------------
7428: ---------------------------------------------------------------
7429: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
7430: ---------------------------------------------------------------
7431: --
7432: for l_parent_rec in c_ecy_from_parent(l_ELIGY_PRFL_ID) loop
7433: --

Line 7596: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------

7592: end loop;
7593: --
7594: end loop;
7595: ---------------------------------------------------------------
7596: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
7597: ---------------------------------------------------------------
7598: ---------------------------------------------------------------
7599: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
7600: ---------------------------------------------------------------