DBA Data[Home] [Help]

APPS.HXC_APPROVAL_UTILITIES dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 800: FROM wf_item_attribute_values

796: IF p_resource_id IS NOT NULL
797: THEN
798: SELECT NUMBER_VALUE
799: INTO l_resource_id
800: FROM wf_item_attribute_values
801: WHERE item_type = l_item_type
802: AND item_key = l_item_key
803: AND name = 'RESOURCE_ID';
804:

Line 823: FROM wf_item_attribute_values

819: IF p_from_date IS NOT NULL
820: THEN
821: SELECT DATE_VALUE
822: INTO l_end_date
823: FROM wf_item_attribute_values
824: WHERE item_type = l_item_type
825: AND item_key = l_item_key
826: AND name = 'APP_END_DATE';
827:

Line 846: FROM wf_item_attribute_values

842: IF p_to_date IS NOT NULL
843: THEN
844: SELECT DATE_VALUE
845: INTO l_start_date
846: FROM wf_item_attribute_values
847: WHERE item_type = l_item_type
848: AND item_key = l_item_key
849: AND name = 'APP_START_DATE';
850:

Line 868: FROM wf_item_attribute_values

864: THEN
865:
866: SELECT NUMBER_VALUE
867: INTO l_app_bb_id
868: FROM wf_item_attribute_values
869: WHERE item_type = l_item_type
870: AND item_key = l_item_key
871: AND name = 'APP_BB_ID';
872:

Line 875: FROM wf_item_attribute_values

871: AND name = 'APP_BB_ID';
872:
873: SELECT NUMBER_VALUE
874: INTO l_app_bb_ovn
875: FROM wf_item_attribute_values
876: WHERE item_type = l_item_type
877: AND item_key = l_item_key
878: AND name = 'APP_BB_OVN';
879: