APPS.BEN_PLAN_DESIGN_COPY_PROCESS dependencies on BEN_COPY_ENTITY_RESULTS

Line 93: from ben_copy_entity_results cpe,

89: cpe.information112 full_formula_name,
90: ff_typ.formula_type_name formula_type_name,
91: cpe.information2 effective_start_date,
92: cpe.information3 effective_end_date
93: from ben_copy_entity_results cpe,
94: pqh_copy_entity_txns cet,
95: ff_formula_types ff_typ
96: where cet.copy_entity_txn_id = p_copy_entity_txn_id
97: and cet.copy_entity_txn_id = cpe.copy_entity_txn_id

Line 307: UPDATE ben_copy_entity_results cer

303: );
304:
305: -- submit api is failing if it picks up the end-dated ben entities.
306: -- added nvl for non-date tracked entities
307: UPDATE ben_copy_entity_results cer
308: set number_of_copies = 0
309: where cer.copy_entity_txn_id = p_copy_entity_txn_id
310: and l_txn_effective_date between nvl(information2,l_txn_effective_date) and nvl(information3,l_txn_effective_date)
311: and cer.dml_operation = 'DELETE';