DBA Data[Home] [Help]

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on AP_WEB_OA_ACTIVE_PKG

Line 521: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,erh.report_header_id) in ('EMPAPPR','RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED')

517: and nvl(cct.billed_date, cct.posted_date) between
518: nvl(p_billedStartDate, nvl(cct.billed_date, cct.posted_date)-1) and
519: nvl(p_billedEndDate, nvl(cct.billed_date, cct.posted_date)+1)
520: and erh.report_header_id = cct.report_header_id
521: and AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(erh.source,erh.workflow_approved_flag,erh.report_header_id) in ('EMPAPPR','RESOLUTN','RETURNED','REJECTED','WITHDRAWN', 'SAVED')
522: and ac.employee_id = p_employeeId
523: and cct.inactive_emp_wf_item_key = p_itemkey
524: and rownum < 41
525: order by transaction_date;