DBA Data[Home] [Help]

APPS.PAY_RETRO_UTILS_PKG dependencies on WF_ITEMS

Line 7: g_itemkey wf_items.item_key%type;

3:
4: ------------------------------------------------------------------------------
5: --GLOBALS
6: --
7: g_itemkey wf_items.item_key%type;
8: g_package varchar2(80) := 'PAY_RETRO_UTILS_PKG.';
9:
10: --g_transaction_id hr_wip_transactions.transaction_id%type;
11: --g_transaction_mode hr_wip_transactions.dml_mode%type;

Line 542: select item_key from wf_items

538: r_itemtype varchar2(30) := 'PYRETRO';
539: r_itemkey varchar2(30);
540:
541: cursor csr_retro_scheduled is
542: select item_key from wf_items
543: where item_type = 'PYRETRO'
544: and root_activity = 'PAY_RETROPAY'
545: AND end_date is null;
546: