APPS.POS_WCAPPROVE_PVT dependencies on WF_NOTIFICATION_ATTR_RESP_V

Line 1657: FROM wf_notification_attr_resp_v

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

Line 1753: FROM wf_notification_attr_resp_v

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

Line 1883: FROM wf_notification_attr_resp_v

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

Line 1889: FROM wf_notification_attr_resp_v

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