APPS.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on HR_API_TRANSACTION_STEPS

Line 954: from hr_api_transaction_steps hats

950: ) is
951: --
952: cursor c_txn_step(p_transaction_id number) is
953: select hats.transaction_step_id
954: from hr_api_transaction_steps hats
955: where hats.transaction_id = p_transaction_id
956: and hats.api_name = upper(g_package || 'process_api')
957: order by hats.transaction_step_id;
958: --

Line 1353: where transaction_id = (select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

1349: --
1350: cursor c_icd_transaction is
1351: select *
1352: from ben_icd_transaction
1353: where transaction_id = (select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
1354: order by dml_operation;
1355:
1356: l_proc varchar2(61) := 'process_api' ;
1357: l_validate number;