APPS.QPR_WKFL_UTIL dependencies on WF_ITEMS

Line 668: from wf_items where item_type = QPR_NTFN_ITM_TYPE

664: select item_key, end_date
665: into l_item_key, l_end_date
666: from
667: (select item_key, end_date
668: from wf_items where item_type = QPR_NTFN_ITM_TYPE
669: and item_key like (l_init_key || '%')
670: order by begin_date desc)
671: where rownum < 2;
672: if l_end_date is null then

Line 726: from wf_items

722: -- Done with the assumption that there will be only one active item for
723: -- key l_init_key --
724: begin
725: select item_key into l_item_key
726: from wf_items
727: where item_type = QPR_NTFN_ITM_TYPE
728: and item_key like (l_init_key || '%')
729: and end_date is null
730: and rownum < 2;

Line 779: from wf_items

775: -- Done with the assumption that there will be only one active item for
776: -- key l_init_key --
777: begin
778: select item_key into l_item_key
779: from wf_items
780: where item_type = QPR_NTFN_ITM_TYPE
781: and item_key like (l_init_key || '%')
782: and end_date is null
783: and rownum < 2;