APPS.PQH_WF dependencies on PQH_FYI_NOTIFY

Line 2063: UPDATE pqh_fyi_notify

2059: IS
2060: l_proc VARCHAR2(61) := g_package || 'mark_fyi_sent';
2061: BEGIN
2062: hr_utility.set_location(l_proc || ' Entering',10);
2063: UPDATE pqh_fyi_notify
2064: SET status = p_status
2065: , notification_date = sysdate
2066: WHERE fyi_notified_id = p_fyi_notified_id;
2067: hr_utility.set_location(l_proc || ' Exiting',100);

Line 2084: FROM pqh_fyi_notify

2080: SELECT fyi_notified_id
2081: , notified_name
2082: , notification_event_cd
2083: , notified_type_cd
2084: FROM pqh_fyi_notify
2085: WHERE transaction_id = p_transaction_id
2086: AND transaction_category_id = p_transaction_category_id
2087: AND STATUS IS NULL;
2088: -- r_get_fyi c_get_fyi%ROWTYPE;