APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 1468: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------

1464: ---------------------------------------------------------------
1465: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
1466: ---------------------------------------------------------------
1467: ---------------------------------------------------------------
1468: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
1469: ---------------------------------------------------------------
1470: cursor c_ecq_from_parent(c_ELIGY_PRFL_ID number) is
1471: select elig_cbr_quald_bnf_id
1472: from BEN_ELIG_CBR_QUALD_BNF_F

Line 1472: from BEN_ELIG_CBR_QUALD_BNF_F

1468: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
1469: ---------------------------------------------------------------
1470: cursor c_ecq_from_parent(c_ELIGY_PRFL_ID number) is
1471: select elig_cbr_quald_bnf_id
1472: from BEN_ELIG_CBR_QUALD_BNF_F
1473: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1474: --
1475: cursor c_ecq(c_elig_cbr_quald_bnf_id number,c_mirror_src_entity_result_id number ,
1476: c_table_alias varchar2 ) is

Line 1478: from BEN_ELIG_CBR_QUALD_BNF_F ecq

1474: --
1475: cursor c_ecq(c_elig_cbr_quald_bnf_id number,c_mirror_src_entity_result_id number ,
1476: c_table_alias varchar2 ) is
1477: select ecq.*
1478: from BEN_ELIG_CBR_QUALD_BNF_F ecq
1479: where ecq.elig_cbr_quald_bnf_id = c_elig_cbr_quald_bnf_id
1480: -- and ecq.business_group_id = p_business_group_id
1481: and not exists (
1482: select /* */ null

Line 1489: -- and trt.where_clause = 'BEN_ELIG_CBR_QUALD_BNF_F'

1485: where copy_entity_txn_id = p_copy_entity_txn_id
1486: -- and trt.table_route_id = cpe.table_route_id
1487: and ( -- c_mirror_src_entity_result_id is null or
1488: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1489: -- and trt.where_clause = 'BEN_ELIG_CBR_QUALD_BNF_F'
1490: and cpe.table_alias = c_table_alias
1491: and information1 = c_elig_cbr_quald_bnf_id
1492: -- and information4 = ecq.business_group_id
1493: and information2 = ecq.effective_start_date

Line 1499: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------

1495: );
1496: l_elig_cbr_quald_bnf_id number(15);
1497: l_out_ecq_result_id number(15);
1498: ---------------------------------------------------------------
1499: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
1500: ---------------------------------------------------------------
1501: ---------------------------------------------------------------
1502: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
1503: ---------------------------------------------------------------

Line 4865: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------

4861: ---------------------------------------------------------------
4862: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
4863: ---------------------------------------------------------------
4864: ---------------------------------------------------------------
4865: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
4866: ---------------------------------------------------------------
4867: --
4868: for l_parent_rec in c_ecq_from_parent(l_ELIGY_PRFL_ID) loop
4869: --

Line 4974: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------

4970: end loop;
4971: --
4972: end loop;
4973: ---------------------------------------------------------------
4974: -- END OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
4975: ---------------------------------------------------------------
4976: ---------------------------------------------------------------
4977: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
4978: ---------------------------------------------------------------