APPS.POS_WCAPPROVE_PVT dependencies on WF_NOTIFICATION_ATTR_RESP_V

Line 1658: FROM wf_notification_attr_resp_v

1654:
1655: If (l_notification_id is not null) then
1656: SELECT attribute_value
1657: into l_note
1658: FROM wf_notification_attr_resp_v
1659: WHERE group_id = l_notification_id
1660: AND attribute_name = 'NOTE';
1661: end if;
1662:

Line 1754: FROM wf_notification_attr_resp_v

1750:
1751: If l_notification_id is not null then
1752: SELECT attribute_value
1753: into l_note
1754: FROM wf_notification_attr_resp_v
1755: WHERE group_id = l_notification_id
1756: AND attribute_name = 'NOTE';
1757: end if;
1758:

Line 1884: FROM wf_notification_attr_resp_v

1880: AND status = 'CANCELED';
1881:
1882: CURSOR c_response(p_group_id number) IS
1883: SELECT recipient_role, attribute_value
1884: FROM wf_notification_attr_resp_v
1885: WHERE group_id = p_group_id
1886: AND attribute_name = 'RESULT';
1887:
1888: CURSOR c_response_note(p_group_id number) IS

Line 1890: FROM wf_notification_attr_resp_v

1886: AND attribute_name = 'RESULT';
1887:
1888: CURSOR c_response_note(p_group_id number) IS
1889: SELECT attribute_value
1890: FROM wf_notification_attr_resp_v
1891: WHERE group_id = p_group_id
1892: AND attribute_name = 'NOTE';
1893:
1894: CURSOR c_responderid(p_responder VARCHAR2) IS