APPS.PQH_SS_HISTORY dependencies on HR_API_TRANSACTION_STEPS_S

Line 543: from hr_api_transaction_steps s

539: and approval_history_id > 0 ;
540: --
541: cursor c_th_step (c_txn_id in number) is
542: select *
543: from hr_api_transaction_steps s
544: where transaction_id = c_txn_id
545: and exists (select null
546: from hr_api_transaction_values v
547: where v.transaction_step_id = s.transaction_step_id );

Line 775: from hr_api_transaction_steps s

771: where transaction_history_id = c_txn_id ;
772: --
773: cursor c_ov_step (c_txn_id in number) is
774: select *
775: from hr_api_transaction_steps s
776: where transaction_id = c_txn_id
777: and exists (select null
778: from hr_api_transaction_values v
779: where v.transaction_step_id = s.transaction_step_id );

Line 1144: where v.transaction_step_id in (select s.transaction_step_id from hr_api_transaction_steps s

1140: --
1141: -- Remove values and step which are not part of history.
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 )

Line 1160: delete from hr_api_transaction_steps s

1156: ,'HR_PROCESS_CONTACT_SS.PROCESS_API'
1157: ,'HR_PROCESS_PERSON_SS.PROCESS_API'
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 )

Line 1223: select hr_api_transaction_steps_s.nextval

1219: fetch c_vf_sup_step INTO r_supStep;
1220: --
1221: if c_vf_sup_step%NOTFOUND then
1222: --
1223: select hr_api_transaction_steps_s.nextval
1224: into l_step_id
1225: from dual;
1226:
1227: insert into hr_api_transaction_steps(