DBA Data[Home] [Help]

APPS.BENUTILS dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 5022: ,wf_item_attribute_values choice_attribute

5018: --
5019: cursor c_pending is
5020: select 'Y'
5021: from wf_item_activity_statuses process
5022: ,wf_item_attribute_values choice_attribute
5023: ,wf_item_attribute_values submit_attribute
5024: ,wf_process_activities activity
5025: ,hr_api_transaction_steps step
5026: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'

Line 5023: ,wf_item_attribute_values submit_attribute

5019: cursor c_pending is
5020: select 'Y'
5021: from wf_item_activity_statuses process
5022: ,wf_item_attribute_values choice_attribute
5023: ,wf_item_attribute_values submit_attribute
5024: ,wf_process_activities activity
5025: ,hr_api_transaction_steps step
5026: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'
5027: and activity.process_item_type = activity.activity_item_type

Line 5069: wf_item_attribute_values submit_attribute

5065: from wf_item_activity_statuses process ,
5066: wf_process_activities activity ,
5067: hr_api_transactions txn,
5068: hr_api_transaction_steps step ,
5069: wf_item_attribute_values submit_attribute
5070: where activity.process_name = 'ROOT'
5071: and activity.process_item_type = activity.activity_item_type
5072: and activity.instance_id = process.process_activity
5073: and process.activity_status = 'ACTIVE'