APPS.OTA_AME_ATTRIBUTES dependencies on HR_API_TRANSACTION_STEPS

Line 24: FROM HR_API_TRANSACTION_STEPS

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

Line 48: FROM HR_API_TRANSACTION_STEPS

44: begin
45:
46: SELECT DISTINCT ITEM_KEY
47: INTO c_item_key
48: FROM HR_API_TRANSACTION_STEPS
49: WHERE TRANSACTION_ID=p_transaction_id;
50:
51: return nvl(c_item_key, '-1');
52: EXCEPTION