APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_NOTIFICATION_ATTR_RESP_V

Line 1812: FROM wf_notification_attr_resp_v

1808: AND status = 'CANCELED';
1809:
1810: CURSOR c_response(p_group_id number) IS
1811: SELECT recipient_role, attribute_value
1812: FROM wf_notification_attr_resp_v
1813: WHERE group_id = p_group_id
1814: AND attribute_name = 'RESULT';
1815:
1816: CURSOR c_response_note(p_group_id number) IS

Line 1818: FROM wf_notification_attr_resp_v

1814: AND attribute_name = 'RESULT';
1815:
1816: CURSOR c_response_note(p_group_id number) IS
1817: SELECT attribute_value
1818: FROM wf_notification_attr_resp_v
1819: WHERE group_id = p_group_id
1820: AND attribute_name = 'NOTE';
1821:
1822: /* Bug 1578061: remove the join to wf_notifications. This forces the

Line 2368: FROM wf_notification_attr_resp_v

2364: AND status = 'CANCELED';
2365:
2366: CURSOR c_response(p_group_id number) IS
2367: SELECT recipient_role, attribute_value
2368: FROM wf_notification_attr_resp_v
2369: WHERE group_id = p_group_id
2370: AND attribute_name = 'RESULT';
2371:
2372: CURSOR c_response_note(p_group_id number) IS

Line 2374: FROM wf_notification_attr_resp_v

2370: AND attribute_name = 'RESULT';
2371:
2372: CURSOR c_response_note(p_group_id number) IS
2373: SELECT attribute_value
2374: FROM wf_notification_attr_resp_v
2375: WHERE group_id = p_group_id
2376: AND attribute_name = 'NOTE';
2377:
2378: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */