APPS.HR_TRANS_HISTORY_API dependencies on PQH_SS_STEP_HISTORY

Line 519: FROM PQH_SS_STEP_HISTORY

515: ,INFORMATION27
516: ,INFORMATION28
517: ,INFORMATION29
518: ,INFORMATION30
519: FROM PQH_SS_STEP_HISTORY
520: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
521: AND APPROVAL_HISTORY_ID = P_APPROVAL_HISTORY_ID;
522:
523: l_cnt Integer;

Line 743: FROM PQH_SS_STEP_HISTORY

739: ,last_update_login
740: FROM PQH_SS_VALUE_HISTORY
741: Where step_history_id in
742: ( SELECT STEP_HISTORY_ID
743: FROM PQH_SS_STEP_HISTORY
744: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
745: AND APPROVAL_HISTORY_ID = P_APPROVAL_HISTORY_ID)
746: AND APPROVAL_HISTORY_ID = P_APPROVAL_HISTORY_ID;
747:

Line 832: FROM PQH_SS_STEP_HISTORY

828: ln_max_seq_id number;
829: -- Cursor to return Min and Max seq for old transactions step hist
830: CURSOR getMinMaxOldSeq IS
831: SELECT MIN(APPROVAL_HISTORY_ID),MAX(APPROVAL_HISTORY_ID)
832: FROM PQH_SS_STEP_HISTORY
833: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID;
834:
835:
836: CURSOR origValUpgTrans IS

Line 838: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val

834:
835:
836: CURSOR origValUpgTrans IS
837: SELECT TRANSACTION_VALUE_ID, VALUE, ORIGINAL_VALUE
838: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val
839: WHERE step.TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
840: and step.step_history_id = val.step_history_id
841: and step.approval_history_id = val.approval_history_id
842: and val.approval_history_id = -1;

Line 846: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val

842: and val.approval_history_id = -1;
843:
844: CURSOR PsuedoValUpgTrans IS
845: SELECT 1
846: FROM PQH_SS_STEP_HISTORY step, PQH_SS_VALUE_HISTORY val
847: WHERE step.TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
848: and step.step_history_id = val.step_history_id
849: and step.approval_history_id = val.approval_history_id
850: and val.approval_history_id = 0

Line 955: from PQH_SS_STEP_HISTORY

951: -- and value history
952: if(l_seq_id =0) then
953: begin
954: select 'Y' into lv_found
955: from PQH_SS_STEP_HISTORY
956: where TRANSACTION_HISTORY_ID =P_TRANSACTION_ID
957: and API_NAME='HR_LOA_SS.PROCESS_API';
958: exception
959: when no_data_found then

Line 1046: FROM pqh_ss_step_history

1042: DELETE pqh_ss_value_history
1043: WHERE approval_history_id = l_seq_id
1044: and step_history_id in (
1045: SELECT step_history_id
1046: FROM pqh_ss_step_history
1047: WHERE transaction_history_id = P_TRANSACTION_ID
1048: and approval_history_id = l_seq_id
1049: );
1050:

Line 1052: DELETE pqh_ss_step_history

1048: and approval_history_id = l_seq_id
1049: );
1050:
1051: -- Delete Steps History
1052: DELETE pqh_ss_step_history
1053: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1054: and approval_history_id = l_seq_id;
1055:
1056: -- Delete Per Pay Trans History

Line 1562: INSERT INTO pqh_ss_step_history

1558: CLOSE cur_trans_steps;
1559: l_cnt := TxStepTbl.STEP_HISTORY_ID.count;
1560:
1561: For i in 1 .. l_cnt Loop
1562: INSERT INTO pqh_ss_step_history
1563: (
1564: STEP_HISTORY_ID
1565: ,APPROVAL_HISTORY_ID
1566: ,TRANSACTION_HISTORY_ID