DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_API_TRANSACTION_STEPS

Line 6933: DELETE FROM hr_api_transaction_steps step

6929: BULK COLLECT INTO l_sc_ids LIMIT 1000;
6930:
6931: --Delete any transactions from HR_API_Transactions and transaction steps
6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id
6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)

Line 8027: DELETE FROM hr_api_transaction_steps step

8023: --
8024: PROCEDURE remove_scorecard_details (p_scorecard_id IN NUMBER)
8025: IS
8026: BEGIN
8027: DELETE FROM hr_api_transaction_steps step
8028: WHERE step.transaction_id IN (
8029: SELECT trn.transaction_id
8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id