APPS.PQH_SS_HISTORY dependencies on PQH_SS_TRANSACTION_HISTORY

Line 114: insert into pqh_ss_transaction_history (

110: p_last_update_date in date,
111: p_last_updated_by in number,
112: p_last_update_login in number) is
113: begin
114: insert into pqh_ss_transaction_history (
115: transaction_history_id ,
116: creator_person_id ,
117: assignment_id ,
118: selected_person_id ,

Line 532: from pqh_ss_transaction_history

528: where transaction_id = c_txn_id;
529: --
530: cursor c_th_txn_h (c_txn_id in number) is
531: select null
532: from pqh_ss_transaction_history
533: where transaction_history_id = c_txn_id ;
534: --
535: cursor c_th_appr_h (c_txn_id in number) is
536: select nvl(max(approval_history_id),0)+1 approval_history_id

Line 770: from pqh_ss_transaction_history

766: where transaction_id = c_txn_id;
767: --
768: cursor c_ov_txn_h (c_txn_id in number) is
769: select null
770: from pqh_ss_transaction_history
771: where transaction_history_id = c_txn_id ;
772: --
773: cursor c_ov_step (c_txn_id in number) is
774: select *

Line 975: from pqh_ss_transaction_history

971: where transaction_id = c_txn_id;
972: --
973: cursor c_vt_txn_h (c_txn_id in number) is
974: select null
975: from pqh_ss_transaction_history
976: where transaction_history_id = c_txn_id ;
977: --
978: dummy varchar2(10);
979: tn c_vt_txn%ROWTYPE;