DBA Data[Home] [Help]

APPS.BENUTILS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 5021: from wf_item_activity_statuses process

5017: return varchar2 is
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

Line 5065: from wf_item_activity_statuses process ,

5061: cursor in_wf(p_person_id NUMBER) is
5062: -- maagrawa (23/Sep/2005)
5063: -- re-wrote query for performance in case this function is used.
5064: select 'Y'
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