DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 6462: FROM WF_ITEM_ATTRIBUTE_VALUES

6458:
6459: BEGIN
6460: SELECT NUMBER_VALUE
6461: INTO l_user_id
6462: FROM WF_ITEM_ATTRIBUTE_VALUES
6463: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6464: AND ITEM_TYPE = 'OEOL'
6465: AND NAME = 'USER_ID';
6466:

Line 6469: FROM WF_ITEM_ATTRIBUTE_VALUES

6465: AND NAME = 'USER_ID';
6466:
6467: SELECT NUMBER_VALUE
6468: INTO l_resp_id
6469: FROM WF_ITEM_ATTRIBUTE_VALUES
6470: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6471: AND ITEM_TYPE = 'OEOL'
6472: AND NAME = 'RESPONSIBILITY_ID';
6473:

Line 6476: FROM WF_ITEM_ATTRIBUTE_VALUES

6472: AND NAME = 'RESPONSIBILITY_ID';
6473:
6474: SELECT NUMBER_VALUE
6475: INTO l_appl_id
6476: FROM WF_ITEM_ATTRIBUTE_VALUES
6477: WHERE ITEM_KEY = to_char(p_line_rec.line_id)
6478: AND ITEM_TYPE = 'OEOL'
6479: AND NAME = 'APPLICATION_ID';
6480: