DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on HR_API_TRANSACTION_VALUES

Line 407: from hr_api_transaction_values

403: ,name
404: ,varchar2_value
405: ,number_value
406: ,date_value
407: from hr_api_transaction_values
408: where transaction_step_id = c_transaction_step_id
409: order by transaction_value_id, datatype;
410:
411: Cursor c_ler (p_typ_cd in varchar2) is

Line 4287: DELETE FROM hr_api_transaction_values

4283: ,p_transaction_id =>p_txn_id);
4284: ELSE
4285: FOR rec_typ IN csr_trans_steps(p_txn_id)
4286: LOOP
4287: DELETE FROM hr_api_transaction_values
4288: WHERE transaction_step_id=rec_typ.transaction_step_id;
4289: END LOOP;
4290: DELETE FROM hr_api_transaction_steps
4291: WHERE transaction_id=p_txn_id;