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 512: select item_key from wf_items

508: r_itemtype varchar2(30) := 'PYRETRO';
509: r_itemkey varchar2(30);
510:
511: cursor csr_retro_scheduled is
512: select item_key from wf_items
513: where item_type = 'PYRETRO'
514: and root_activity = 'PAY_RETROPAY'
515: AND end_date is null;
516: