DBA Data[Home] [Help]

APPS.HR_TRANS_HISTORY_API dependencies on PER_PAY_TRANSACTIONS

Line 328: delete from per_pay_transactions where transaction_step_id = P_TRANSACTION_STEP_ID;

324: where approval_history_id = C_APPROVAL_HISTORY_ID
325: and transaction_step_id = P_TRANSACTION_STEP_ID;
326: BEGIN
327: --
328: delete from per_pay_transactions where transaction_step_id = P_TRANSACTION_STEP_ID;
329: --
330: for csr_per_pay_trans_hist_rec in csr_per_pay_trans_hist(P_APPROVAL_HISTORY_ID)
331: loop
332: --

Line 333: Insert into per_pay_transactions

329: --
330: for csr_per_pay_trans_hist_rec in csr_per_pay_trans_hist(P_APPROVAL_HISTORY_ID)
331: loop
332: --
333: Insert into per_pay_transactions
334: ( pay_transaction_id,
335: transaction_id ,
336: transaction_step_id,
337: item_type ,

Line 1210: from per_pay_transactions

1206: status ,
1207: dml_operation ,
1208: display_cd ,
1209: txn_dml_operation
1210: from per_pay_transactions
1211: where transaction_step_id = P_TRANSACTION_STEP_ID;
1212:
1213: BEGIN
1214: for csr_per_pay_trans_rec in csr_per_pay_trans