DBA Data[Home] [Help]

APPS.IEX_WF_BAN_STATUS_PUB dependencies on WF_ITEM_ATTR_VALUES_ONDEMAND

Line 1585: select distinct item_key from wf_item_attr_values_ondemand

1581: -- Begin bug 7703313
1582: l_itemkey varchar2(240);
1583:
1584: cursor get_cr_itemkey(c_id number) is
1585: select distinct item_key from wf_item_attr_values_ondemand
1586: where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCR';
1587: cursor get_cs_itemkey(c_id number) is
1588: select distinct item_key from wf_item_attr_values_ondemand
1589: where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCS';

Line 1588: select distinct item_key from wf_item_attr_values_ondemand

1584: cursor get_cr_itemkey(c_id number) is
1585: select distinct item_key from wf_item_attr_values_ondemand
1586: where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCR';
1587: cursor get_cs_itemkey(c_id number) is
1588: select distinct item_key from wf_item_attr_values_ondemand
1589: where name = 'BANKRUPTCY_ID' and number_value = c_id and item_type = 'IEXDELCS';
1590: -- End bug 7703313
1591:
1592: begin