APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_AGE_PRTE_F

Line 1268: -- and tr.where_clause = l_BEN_ELIG_AGE_PRTE_F

1264: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1265: pqh_table_route tr
1266: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1267: and cpe.table_route_id = tr.table_route_id
1268: -- and tr.where_clause = l_BEN_ELIG_AGE_PRTE_F
1269: and tr.table_alias = l_table_alias
1270: and cpe.number_of_copies = 1 -- ADDITION
1271:
1272: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode

Line 1307: from BEN_ELIG_AGE_PRTE_F EAP

1303: c_business_group_id number,
1304: c_new_pk_id number) is
1305: select
1306: EAP.elig_age_prte_id new_value
1307: from BEN_ELIG_AGE_PRTE_F EAP
1308: where
1309: EAP.AGE_FCTR_ID = l_AGE_FCTR_ID and -- IK
1310: EAP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
1311: EAP.business_group_id = c_business_group_id

Line 1319: from BEN_ELIG_AGE_PRTE_F EAP1

1315: and effective_end_date ;
1316: --END TEMPIK
1317: /*TEMPIK
1318: and exists ( select null
1319: from BEN_ELIG_AGE_PRTE_F EAP1
1320: where
1321: EAP1.AGE_FCTR_ID = l_AGE_FCTR_ID and -- IK
1322: EAP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
1323: EAP1.business_group_id = c_business_group_id

Line 1326: from BEN_ELIG_AGE_PRTE_F EAP2

1322: EAP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
1323: EAP1.business_group_id = c_business_group_id
1324: and EAP1.effective_start_date <= c_effective_start_date )
1325: and exists ( select null
1326: from BEN_ELIG_AGE_PRTE_F EAP2
1327: where
1328: EAP2.AGE_FCTR_ID = l_AGE_FCTR_ID and -- IK
1329: EAP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
1330: EAP2.business_group_id = c_business_group_id

Line 1480: (p_base_table_name => 'BEN_ELIG_AGE_PRTE_F',

1476: if c_find_EAP_in_target%found then
1477: --
1478: --TEMPIK
1479: l_dt_rec_found := dt_api.check_min_max_dates
1480: (p_base_table_name => 'BEN_ELIG_AGE_PRTE_F',
1481: p_base_key_column => 'ELIG_AGE_PRTE_ID',
1482: p_base_key_value => l_new_value,
1483: p_from_date => l_min_esd,
1484: p_to_date => l_max_eed );

Line 1540: hr_utility.set_location(' BEN_ELIG_AGE_PRTE_F CREATE_ELIG_AGE_PRTE ',20);

1536: end if;
1537:
1538: if l_first_rec and not l_update then
1539: -- Call Create routine.
1540: hr_utility.set_location(' BEN_ELIG_AGE_PRTE_F CREATE_ELIG_AGE_PRTE ',20);
1541: BEN_ELIG_AGE_PRTE_API.CREATE_ELIG_AGE_PRTE(
1542: --
1543: P_VALIDATE => false
1544: ,P_EFFECTIVE_DATE => l_effective_date

Line 1614: hr_utility.set_location(' BEN_ELIG_AGE_PRTE_F UPDATE_ELIG_AGE_PRTE ',30);

1610: else
1611: --
1612: -- Call Update routine for the pk_id created in prev run .
1613: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1614: hr_utility.set_location(' BEN_ELIG_AGE_PRTE_F UPDATE_ELIG_AGE_PRTE ',30);
1615: --UPD START
1616: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
1617: --
1618: if l_update then