APPS.PQH_SS_HISTORY dependencies on PQH_SS_STEP_HISTORY

Line 215: insert into pqh_ss_step_history

211: p_last_update_date in date,
212: p_last_updated_by in number,
213: p_last_update_login in number) is
214: begin
215: insert into pqh_ss_step_history
216: (step_history_id ,
217: approval_history_id ,
218: transaction_history_id ,
219: api_name ,

Line 683: from pqh_ss_step_history

679: l_var varchar2(20);
680: begin
681: select null
682: into l_var
683: from pqh_ss_step_history
684: where transaction_history_id = p_transaction_history_id
685: and approval_history_id = p_approval_history_id
686: and step_history_id = p_step_history_id;
687:

Line 988: select step_history_id from pqh_ss_step_history

984: --
985: delete from pqh_ss_value_history
986: where approval_history_id = -1
987: and step_history_id in (
988: select step_history_id from pqh_ss_step_history
989: where transaction_history_id = p_txnId
990: and approval_history_id = -1);
991: --
992: hr_utility.set_location('delete value history done', 45);

Line 993: delete from pqh_ss_step_history

989: where transaction_history_id = p_txnId
990: and approval_history_id = -1);
991: --
992: hr_utility.set_location('delete value history done', 45);
993: delete from pqh_ss_step_history
994: where transaction_history_id = p_txnId
995: and approval_history_id = -1;
996:
997: for r_supStep in c_vt_sup_step(p_txnId) loop

Line 1120: FROM pqh_ss_step_history

1116: OR api_name = c_api_name);
1117: --
1118: CURSOR c_vf_sup_step_h (c_txn_id in number) IS
1119: SELECT *
1120: FROM pqh_ss_step_history
1121: WHERE transaction_history_id = c_txn_id
1122: AND approval_history_id = -1
1123: AND api_name in ('HR_SUPERVISOR_SS.PROCESS_API'
1124: ,'HR_PROCESS_SIT_SS.PROCESS_API'

Line 1146: and s.api_name not in (select h.api_name from pqh_ss_step_history h

1142: --
1143: delete from hr_api_transaction_values v
1144: where v.transaction_step_id in (select s.transaction_step_id from hr_api_transaction_steps s
1145: where s.transaction_id = p_txnId
1146: and s.api_name not in (select h.api_name from pqh_ss_step_history h
1147: where transaction_history_id = p_txnId
1148: and approval_history_id = -1 )
1149: and s.api_name in (
1150: 'HR_PAY_RATE_SS.PROCESS_API'

Line 1162: and s.api_name not in (select h.api_name from pqh_ss_step_history h

1158: ,'HR_COMP_PROFILE_SS.PROCESS_API' ));
1159: --
1160: delete from hr_api_transaction_steps s
1161: where s.transaction_id = p_txnId
1162: and s.api_name not in (select h.api_name from pqh_ss_step_history h
1163: where transaction_history_id = p_txnId
1164: and approval_history_id = -1 )
1165: and s.api_name in (
1166: 'HR_PAY_RATE_SS.PROCESS_API'