APPS.PQH_FR_WF_NTF dependencies on PQH_FR_VALIDATION_EVENTS

Line 32: FROM pqh_fr_validation_events

28: l_user_role Varchar2(200);
29: cursor csr_last_event(p_valid_id number)
30: IS
31: SELECT event_code
32: FROM pqh_fr_validation_events
33: WHERE validation_id = p_valid_id
34: ORDER BY creation_date DESC;
35: cursor csr_emp_user IS
36: SELECT user_name

Line 330: FROM pqh_fr_validation_events

326: l_proc varchar2(61) := g_package||':'||'psv_ntf_api';
327: cursor csr_last_event(p_valid_id number)
328: IS
329: SELECT event_code
330: FROM pqh_fr_validation_events
331: WHERE validation_id = p_valid_id
332: ORDER BY creation_date DESC;
333: l_event_code pqh_fr_validation_events.event_code%TYPE;
334: l_validation_id Number;

Line 333: l_event_code pqh_fr_validation_events.event_code%TYPE;

329: SELECT event_code
330: FROM pqh_fr_validation_events
331: WHERE validation_id = p_valid_id
332: ORDER BY creation_date DESC;
333: l_event_code pqh_fr_validation_events.event_code%TYPE;
334: l_validation_id Number;
335: BEGIN
336: l_validation_id := wf_engine.GetItemAttrText(
337: itemtype => itemtype,