APPS.PQH_SS_WORKFLOW dependencies on WF_ITEMS

Line 435: wf_items WI

431: select pa.instance_id
432: FROM wf_process_activities PA,
433: wf_activity_attributes AA,
434: wf_activities WA,
435: wf_items WI
436: WHERE pa.process_item_type = ias.item_type
437: and wa.item_type = pa.process_item_type
438: and wa.name = pa.activity_name
439: and wi.item_type = ias.item_type

Line 462: WF_ITEMS WI

458: select wpa.instance_id
459: FROM WF_PROCESS_ACTIVITIES WPA,
460: WF_ACTIVITY_ATTRIBUTES WAA,
461: WF_ACTIVITIES WA,
462: WF_ITEMS WI
463: WHERE wpa.process_item_type = ias.item_type
464: and wa.item_type = wpa.process_item_type
465: and wa.name = wpa.activity_name
466: and wi.item_type = ias.item_type

Line 527: from WF_ACTIVITIES wa, WF_ACTIVITY_ATTRIBUTES waa, WF_ITEMS wi

523: and ias.item_key = p_itemKey
524: and ias.activity_status = 'NOTIFIED'
525: and ias.process_activity <> p_activity
526: and not exists (select 'e'
527: from WF_ACTIVITIES wa, WF_ACTIVITY_ATTRIBUTES waa, WF_ITEMS wi
528: where wa.item_type = pa.process_item_type
529: and wa.name = pa.activity_name
530: and wi.item_type = ias.item_type
531: and wi.item_key = ias.item_key

Line 3515: ,wf_items i

3511: ,ias.begin_date) h_action_date
3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT
3517: where IAS.ITEM_TYPE = 'HRSSA'
3518: and IAS.ITEM_KEY = '15018'
3519: and IAS.NOTIFICATION_ID is not null

Line 3548: ,wf_items i

3544: ,ias.begin_date) h_action_date
3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT
3550: where IAS.ITEM_TYPE = 'HRSSA'
3551: and IAS.ITEM_KEY = '15018'
3552: and IAS.NOTIFICATION_ID is not null

Line 3658: from WF_ITEMS

3654:
3655: begin
3656: select OWNER_ROLE, BEGIN_DATE
3657: into l_owner_role, l_begin_date
3658: from WF_ITEMS
3659: where ITEM_TYPE = l_itype
3660: and ITEM_KEY = l_ikey;
3661: exception
3662: when OTHERS then