DBA Data[Home] [Help]

APPS.AP_WEB_RECEIPT_MANAGEMENT_UTIL dependencies on WF_ITEMS

Line 487: from wf_items wf

483: p_shortpay_type IN VARCHAR2) RETURN VARCHAR2 IS
484:
485: CURSOR wf_cur IS
486: select 1
487: from wf_items wf
488: where wf.item_type = 'APEXP'
489: and wf.item_key = to_char(p_report_header_id) -- Bug 6841589 (sodash) to solve the invalid number exception
490: and wf.end_date is null
491: and wf.root_activity = p_shortpay_type

Line 631: wf_items wf

627: ------------------------------------------------------------
628: select 'Y'
629: into l_is_shortpay
630: from ap_expense_report_headers_all aerh,
631: wf_items wf
632: where aerh.report_header_id = p_report_header_id
633: and aerh.shortpay_parent_id is not null
634: and wf.item_type = 'APEXP'
635: and wf.item_key = to_char(aerh.report_header_id)