DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_API_TRANSACTION_STEPS

Line 5214: FROM hr_api_transaction_steps step

5210: FETCH csr_sc_ids BULK COLLECT INTO l_sc_ids LIMIT 1000;
5211: --Delete any transactions from HR_API_Transactions and transaction steps
5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id
5216: FROM hr_api_transactions trn
5217: WHERE trn.transaction_ref_id =
5218: l_sc_ids(i)

Line 6067: FROM hr_api_transaction_steps step

6063: --
6064: PROCEDURE remove_scorecard_details(p_scorecard_id IN NUMBER) IS
6065: BEGIN
6066: DELETE
6067: FROM hr_api_transaction_steps step
6068: WHERE step.transaction_id IN (SELECT trn.transaction_id
6069: FROM hr_api_transactions trn
6070: WHERE trn.transaction_ref_id =
6071: p_scorecard_id