DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 2487: FROM wf_item_attribute_values

2483:
2484: /*Added for ER 13869562*/
2485: CURSOR validate_wf_attribute(p_item_key varchar2) IS
2486: SELECT text_value
2487: FROM wf_item_attribute_values
2488: WHERE item_type=G_ITEM_TYPE
2489: AND item_key=p_item_key
2490: AND name = 'CC_EMAIL';
2491:

Line 2826: FROM wf_item_attribute_values

2822: /*Added for ER 13869562 spingali*/
2823:
2824: CURSOR validate_wf_attribute(p_item_key VARCHAR2) IS
2825: SELECT text_value
2826: FROM wf_item_attribute_values
2827: WHERE item_type=G_ITEM_TYPE
2828: AND item_key=p_item_key
2829: AND name = 'CC_EMAIL';
2830:

Line 5195: FROM wf_item_attribute_values wiav,

5191:
5192: CURSOR l_user_dtls_csr(p_chr_id NUMBER) IS
5193: SELECT wiav.name attr_name,
5194: wiav.number_value attr_value
5195: FROM wf_item_attribute_values wiav,
5196: wf_item_attributes wia
5197: WHERE wiav.item_type = 'OKSARENW'
5198: AND wiav.item_key = p_chr_id
5199: AND wia.item_type = wiav.item_type