APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_QUAL_TITL_PRTE_F

Line 3359: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------

3355: ---------------------------------------------------------------
3356: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
3357: ---------------------------------------------------------------
3358: ---------------------------------------------------------------
3359: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
3360: ---------------------------------------------------------------
3361: cursor c_eqt_from_parent(c_ELIGY_PRFL_ID number) is
3362: select elig_qual_titl_prte_id
3363: from BEN_ELIG_QUAL_TITL_PRTE_F

Line 3363: from BEN_ELIG_QUAL_TITL_PRTE_F

3359: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
3360: ---------------------------------------------------------------
3361: cursor c_eqt_from_parent(c_ELIGY_PRFL_ID number) is
3362: select elig_qual_titl_prte_id
3363: from BEN_ELIG_QUAL_TITL_PRTE_F
3364: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3365: --
3366: cursor c_eqt(c_elig_qual_titl_prte_id number,c_mirror_src_entity_result_id number ,
3367: c_table_alias varchar2 ) is

Line 3369: from BEN_ELIG_QUAL_TITL_PRTE_F eqt

3365: --
3366: cursor c_eqt(c_elig_qual_titl_prte_id number,c_mirror_src_entity_result_id number ,
3367: c_table_alias varchar2 ) is
3368: select eqt.*
3369: from BEN_ELIG_QUAL_TITL_PRTE_F eqt
3370: where eqt.elig_qual_titl_prte_id = c_elig_qual_titl_prte_id
3371: -- and eqt.business_group_id = p_business_group_id
3372: and not exists (
3373: select /* */ null

Line 3380: -- and trt.where_clause = 'BEN_ELIG_QUAL_TITL_PRTE_F'

3376: where copy_entity_txn_id = p_copy_entity_txn_id
3377: -- and trt.table_route_id = cpe.table_route_id
3378: and ( -- c_mirror_src_entity_result_id is null or
3379: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3380: -- and trt.where_clause = 'BEN_ELIG_QUAL_TITL_PRTE_F'
3381: and cpe.table_alias = c_table_alias
3382: and information1 = c_elig_qual_titl_prte_id
3383: -- and information4 = eqt.business_group_id
3384: and information2 = eqt.effective_start_date

Line 3398: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------

3394: from per_qualification_types_vl
3395: where qualification_type_id = p_id;
3396:
3397: ---------------------------------------------------------------
3398: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
3399: ---------------------------------------------------------------
3400: ---------------------------------------------------------------
3401: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
3402: ---------------------------------------------------------------

Line 10582: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------

10578: ---------------------------------------------------------------
10579: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
10580: ---------------------------------------------------------------
10581: ---------------------------------------------------------------
10582: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
10583: ---------------------------------------------------------------
10584: --
10585: for l_parent_rec in c_eqt_from_parent(l_ELIGY_PRFL_ID) loop
10586: --

Line 10715: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------

10711: end loop;
10712: --
10713: end loop;
10714: ---------------------------------------------------------------
10715: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
10716: ---------------------------------------------------------------
10717: ---------------------------------------------------------------
10718: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
10719: ---------------------------------------------------------------