448: AND apv.distribution_line_number = -1
449: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
450: AND aerh.source <> 'Both Pay'
451: AND NVL(aerh.expense_status_code,
452: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.Source,
453: aerh.Workflow_approved_flag,
454: aerh.report_header_id,
455: 'N'
456: )) IN ('MGRPAYAPPR','INVOICED','PAID')
509: AND apv.distribution_line_number = -1
510: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
511: AND aerh.source <> 'Both Pay'
512: AND NVL(aerh.expense_status_code,
513: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.Source,
514: aerh.Workflow_approved_flag,
515: aerh.report_header_id,
516: 'N'
517: )) IN ('MGRPAYAPPR','INVOICED','PAID')
1089: AND apv.distribution_line_number = -1
1090: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
1091: AND aerh.source <> 'Both Pay'
1092: AND NVL(aerh.expense_status_code,
1093: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.Source,
1094: aerh.Workflow_approved_flag,
1095: aerh.report_header_id,
1096: 'N'
1097: )) IN ('MGRPAYAPPR','INVOICED','PAID')
1122: AND apv.distribution_line_number = -1
1123: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
1124: AND aerh.source <> 'Both Pay'
1125: AND NVL(aerh.expense_status_code,
1126: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.source,
1127: aerh.workflow_approved_flag,
1128: aerh.report_header_id,
1129: 'N'
1130: )) IN ('MGRPAYAPPR','INVOICED','PAID')
1612: AND apv.distribution_line_number = -1
1613: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
1614: AND aerh.source <> 'Both Pay'
1615: AND NVL(aerh.expense_status_code,
1616: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.Source,
1617: aerh.Workflow_approved_flag,
1618: aerh.report_header_id,
1619: 'N'
1620: )) IN ('MGRPAYAPPR','INVOICED','PAID')
1645: AND apv.distribution_line_number = -1
1646: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
1647: AND aerh.source <> 'Both Pay'
1648: AND NVL(aerh.expense_status_code,
1649: AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(aerh.source,
1650: aerh.workflow_approved_flag,
1651: aerh.report_header_id,
1652: 'N'
1653: )) IN ('MGRPAYAPPR','INVOICED','PAID')