APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 640: wf_item_attribute_values wav

636: CURSOR cur_sfl IS
637: SELECT nvl(decode(wav.text_value, null, hat.status,
638: decode(hat.status,'S','SUBMIT',hat.status)),'N')
639: FROM hr_api_transactions hat,
640: wf_item_attribute_values wav
641: WHERE hat.item_type = wav.item_Type
642: AND hat.item_key = wav.item_Key
643: AND wav.item_type = itemType
644: AND wav.item_key = itemKey

Line 1936: --need to remove transaction_id from wf_item_attribute_values also

1932: hr_transaction_api.rollback_transaction
1933: (p_transaction_id => l_transactionId );
1934:
1935: --3099089 change starts
1936: --need to remove transaction_id from wf_item_attribute_values also
1937: wf_engine.setitemattrnumber
1938: (itemtype => itemtype
1939: ,itemkey => itemkey
1940: ,aname => 'TRANSACTION_ID'

Line 2076: FROM wf_item_attribute_values

2072:
2073: -- Cursor to find if the person (selected for RFC) is an additional approver
2074: CURSOR cur_add_appr IS
2075: SELECT 'X'
2076: FROM wf_item_attribute_values
2077: WHERE item_type = p_itemType
2078: AND item_key = p_itemKey
2079: AND name like 'ADDITIONAL_APPROVER_%'
2080: AND number_value = p_userId;

Line 2113: FROM wf_item_attribute_values

2109: )
2110: and approval_history_id > 0
2111: MINUS
2112: SELECT number_value
2113: FROM wf_item_attribute_values
2114: WHERE item_type = p_itemType
2115: AND item_key = p_itemKey
2116: AND name like 'ADDITIONAL_APPROVER_%'
2117: )