DBA Data[Home] [Help]

APPS.PQH_SS_UTILITY dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 470: FROM wf_item_attribute_values iav2

466: WHERE tsv.transaction_step_id = ts.transaction_step_id
467: AND tsv.name = 'P_REVIEW_PROC_CALL'
468: AND tsv.varchar2_value IS NOT NULL)
469: AND EXISTS (SELECT NULL
470: FROM wf_item_attribute_values iav2
471: WHERE iav2.item_type = ts.item_type
472: AND iav2.item_key = ts.item_key
473: AND iav2.name = 'TRAN_SUBMIT'
474: AND iav2.text_value = 'Y')

Line 476: FROM wf_item_attribute_values iav

472: AND iav2.item_key = ts.item_key
473: AND iav2.name = 'TRAN_SUBMIT'
474: AND iav2.text_value = 'Y')
475: AND EXISTS (SELECT NULL
476: FROM wf_item_attribute_values iav
477: WHERE iav.item_type = ts.item_type
478: AND iav.item_key = ts.item_key
479: AND iav.name = 'CURRENT_ASSIGNMENT_ID'
480: AND iav.number_value = p_assignId)