APPS.OT_WORKFLOW_SS dependencies on HR_API_TRANSACTION_STEPS

Line 26: FROM HR_API_TRANSACTION_STEPS

22: begin
23:
24: SELECT DISTINCT ITEM_TYPE
25: INTO c_item_type
26: FROM HR_API_TRANSACTION_STEPS
27: WHERE TRANSACTION_ID=p_transaction_id;
28:
29: return nvl(c_item_type, '-1');
30: EXCEPTION

Line 57: FROM HR_API_TRANSACTION_STEPS

53: begin
54:
55: SELECT DISTINCT ITEM_KEY
56: INTO c_item_key
57: FROM HR_API_TRANSACTION_STEPS
58: WHERE TRANSACTION_ID=p_transaction_id;
59:
60: return nvl(c_item_key, '-1');
61: EXCEPTION