APPS.IRC_OFFERS_API dependencies on WF_NOTIFICATIONS
Line 1467: wf_notifications wn
1463: select hat.transaction_id
1464: ,wn.MESSAGE_TYPE
1465: ,wn.item_key
1466: from hr_api_transactions hat, 1467: wf_notifications wn 1468: where hat.transaction_ref_table='IRC_OFFERS'
1469: and hat.STATUS='S'
1470: and wn.MESSAGE_TYPE='HRSFL'
1471: and to_char(hat.transaction_id)=wn.user_key