APPS.ZPB_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 1099: from WF_ITEM_ATTRIBUTE_VALUES

1095: -- agb 01/21/02 added for select below
1096: -- 04/23/03 agb ZPBSCHED Need to take this further and eliminate item type restriction.
1097: CURSOR c_ItemKeys is
1098: select item_type, item_key
1099: from WF_ITEM_ATTRIBUTE_VALUES
1100: where (item_type = 'ZPBSCHED' OR item_type = 'EPBCYCLE')
1101: and name = AttrName
1102: and number_value = inACID;
1103:

Line 3673: from WF_ITEM_ATTRIBUTE_VALUES

3669:
3670: -- get RespId and RespAppId from params set on the workflow sched for this BP
3671: CURSOR c_wfItemKey is
3672: select /*+ FIRST_ROWS */ item_key
3673: from WF_ITEM_ATTRIBUTE_VALUES
3674: where item_type = 'ZPBSCHED'
3675: and name = 'ACID'
3676: and number_value = ACID;
3677: v_wfItemKey c_wfItemKey%ROWTYPE;

Line 4059: from WF_ITEM_ATTRIBUTE_VALUES

4055: result varchar2(100);
4056:
4057: CURSOR c_ItemKeys is
4058: select item_type, item_key
4059: from WF_ITEM_ATTRIBUTE_VALUES
4060: where item_type = 'ZPBSCHED'
4061: and name = AttrName
4062: and number_value = inACID;
4063:

Line 4131: from WF_ITEM_ATTRIBUTE_VALUES

4127: -- Need itemKey for ACID to get variables to set context before
4128: -- calling SUBMIT_REQUEST
4129: CURSOR c_wfItemKey is
4130: select /*+ FIRST_ROWS */ item_key
4131: from WF_ITEM_ATTRIBUTE_VALUES
4132: where item_type = 'ZPBSCHED'
4133: and name = 'ACID'
4134: and number_value = ACId;
4135: v_wfItemKey c_wfItemKey%ROWTYPE;