DBA Data[Home] [Help]

APPS.HR_TRANS_HISTORY_API dependencies on PER_PAY_TRANSACTION_HISTORY

Line 323: from per_pay_transaction_history

319: status ,
320: dml_operation ,
321: display_cd ,
322: txn_dml_operation
323: from per_pay_transaction_history
324: where approval_history_id = C_APPROVAL_HISTORY_ID
325: and transaction_step_id = P_TRANSACTION_STEP_ID;
326: BEGIN
327: --

Line 1057: DELETE per_pay_transaction_history

1053: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1054: and approval_history_id = l_seq_id;
1055:
1056: -- Delete Per Pay Trans History
1057: DELETE per_pay_transaction_history
1058: WHERE TRANSACTION_ID = P_TRANSACTION_ID
1059: and approval_history_id = l_seq_id;
1060:
1061: IF P_ACTION NOT IN ('SFL', 'SUBMIT', 'RESUBMIT') THEN

Line 1216: Insert into per_pay_transaction_history

1212:
1213: BEGIN
1214: for csr_per_pay_trans_rec in csr_per_pay_trans
1215: loop
1216: Insert into per_pay_transaction_history
1217: ( pay_transaction_id,
1218: APPROVAL_HISTORY_ID,
1219: transaction_id ,
1220: transaction_step_id,