APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 637: wf_item_attribute_values wav

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

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

1909: hr_transaction_api.rollback_transaction
1910: (p_transaction_id => l_transactionId );
1911:
1912: --3099089 change starts
1913: --need to remove transaction_id from wf_item_attribute_values also
1914: wf_engine.setitemattrnumber
1915: (itemtype => itemtype
1916: ,itemkey => itemkey
1917: ,aname => 'TRANSACTION_ID'

Line 2053: FROM wf_item_attribute_values

2049:
2050: -- Cursor to find if the person (selected for RFC) is an additional approver
2051: CURSOR cur_add_appr IS
2052: SELECT 'X'
2053: FROM wf_item_attribute_values
2054: WHERE item_type = p_itemType
2055: AND item_key = p_itemKey
2056: AND name like 'ADDITIONAL_APPROVER_%'
2057: AND number_value = p_userId;

Line 2090: FROM wf_item_attribute_values

2086: )
2087: and approval_history_id > 0
2088: MINUS
2089: SELECT number_value
2090: FROM wf_item_attribute_values
2091: WHERE item_type = p_itemType
2092: AND item_key = p_itemKey
2093: AND name like 'ADDITIONAL_APPROVER_%'
2094: )