APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 1337: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------

1333: ---------------------------------------------------------------
1334: -- END OF BEN_ELIG_AGE_PRTE_F ----------------------
1335: ---------------------------------------------------------------
1336: ---------------------------------------------------------------
1337: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
1338: ---------------------------------------------------------------
1339: cursor c_ean_from_parent(c_ELIGY_PRFL_ID number) is
1340: select elig_asnt_set_prte_id
1341: from BEN_ELIG_ASNT_SET_PRTE_F

Line 1341: from BEN_ELIG_ASNT_SET_PRTE_F

1337: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
1338: ---------------------------------------------------------------
1339: cursor c_ean_from_parent(c_ELIGY_PRFL_ID number) is
1340: select elig_asnt_set_prte_id
1341: from BEN_ELIG_ASNT_SET_PRTE_F
1342: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1343: --
1344: cursor c_ean(c_elig_asnt_set_prte_id number,c_mirror_src_entity_result_id number ,
1345: c_table_alias varchar2 ) is

Line 1347: from BEN_ELIG_ASNT_SET_PRTE_F ean

1343: --
1344: cursor c_ean(c_elig_asnt_set_prte_id number,c_mirror_src_entity_result_id number ,
1345: c_table_alias varchar2 ) is
1346: select ean.*
1347: from BEN_ELIG_ASNT_SET_PRTE_F ean
1348: where ean.elig_asnt_set_prte_id = c_elig_asnt_set_prte_id
1349: -- and ean.business_group_id = p_business_group_id
1350: and not exists (
1351: select /* */ null

Line 1358: -- and trt.where_clause = 'BEN_ELIG_ASNT_SET_PRTE_F'

1354: where copy_entity_txn_id = p_copy_entity_txn_id
1355: -- and trt.table_route_id = cpe.table_route_id
1356: and ( -- c_mirror_src_entity_result_id is null or
1357: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1358: -- and trt.where_clause = 'BEN_ELIG_ASNT_SET_PRTE_F'
1359: and cpe.table_alias = c_table_alias
1360: and information1 = c_elig_asnt_set_prte_id
1361: -- and information4 = ean.business_group_id
1362: and information2 = ean.effective_start_date

Line 1383: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------

1379: l_mapping_column_name2 pqh_attributes.attribute_name%type;
1380: l_information172 varchar2(300);
1381: --
1382: ---------------------------------------------------------------
1383: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
1384: ---------------------------------------------------------------
1385: ---------------------------------------------------------------
1386: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
1387: ---------------------------------------------------------------

Line 4507: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------

4503: ---------------------------------------------------------------
4504: -- END OF BEN_ELIG_AGE_PRTE_F ----------------------
4505: ---------------------------------------------------------------
4506: ---------------------------------------------------------------
4507: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
4508: ---------------------------------------------------------------
4509: --
4510: for l_parent_rec in c_ean_from_parent(l_ELIGY_PRFL_ID) loop
4511: --

Line 4639: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------

4635: end loop;
4636: --
4637: end loop;
4638: ---------------------------------------------------------------
4639: -- END OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
4640: ---------------------------------------------------------------
4641: ---------------------------------------------------------------
4642: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
4643: ---------------------------------------------------------------