APPS.HR_TRANS_HISTORY_API dependencies on HR_API_TRANSACTIONS

Line 151: FROM pqh_ss_approval_history ah, HR_API_TRANSACTIONS tx

147: ,ah.CREATION_DATE
148: ,ah.LAST_UPDATE_DATE
149: ,ah.LAST_UPDATED_BY
150: ,ah.LAST_UPDATE_LOGIN
151: FROM pqh_ss_approval_history ah, HR_API_TRANSACTIONS tx
152: WHERE TRANSACTION_ID = TRANSACTION_HISTORY_ID
153: AND TRANSACTION_HISTORY_ID = P_TRANSACTION_ID;
154:
155: -- Note: Heena - Can we use only PQH_SS_APPROVAL_HISTORY ?

Line 174: -- from PQH_SS_APPROVAL_HISTORY and HR_API_TRANSACTIONS

170: FETCH getMaxOldSeq INTO l_seq_id;
171: CLOSE getMaxOldSeq;
172: IF (l_seq_id IS NOT NULL) THEN
173: -- populate PQH_SS_TRANS_STATE_HISTORY
174: -- from PQH_SS_APPROVAL_HISTORY and HR_API_TRANSACTIONS
175: NULL;
176: OPEN populateStateTable;
177: FETCH populateStateTable BULK COLLECT INTO
178: stateTbl.TRANSACTION_HISTORY_ID

Line 914: UPDATE HR_API_TRANSACTIONS

910: hr_utility.set_location('Entering: '|| l_proc,5);
911: l_seq_id := getTransStateSequence(P_TRANSACTION_ID => P_TRANSACTION_ID);
912:
913: -- Copy Transaction details from history.
914: UPDATE HR_API_TRANSACTIONS
915: SET (
916: STATUS
917: ,TRANSACTION_STATE
918: ,TRANSACTION_EFFECTIVE_DATE

Line 1100: FROM HR_API_TRANSACTIONS

1096: lv_orig_system_id wf_roles.orig_system_id%type;
1097:
1098: CURSOR cur_trans_details IS
1099: SELECT ITEM_TYPE, ITEM_KEY, TRANSACTION_EFFECTIVE_DATE, EFFECTIVE_DATE_OPTION
1100: FROM HR_API_TRANSACTIONS
1101: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
1102:
1103: l_row cur_trans_details%RowType;
1104: Begin

Line 1735: FROM hr_api_transactions t, pqh_ss_transaction_history pt

1731: ,t.PARENT_TRANSACTION_ID
1732: ,t.RELAUNCH_FUNCTION
1733: ,t.TRANSACTION_DOCUMENT
1734: ,pt.transaction_history_id
1735: FROM hr_api_transactions t, pqh_ss_transaction_history pt
1736: WHERE transaction_id = P_TRANSACTION_ID
1737: AND t.transaction_id = pt.transaction_history_ID (+);
1738:
1739: l_trans_details_row cur_trans_details%ROWTYPE;