APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_RECEIPT_MANAGEMENT_UTIL

Line 800: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED

796: FROM ap_expense_report_lines aerl,
797: ap_expense_report_headers aerh
798: WHERE aerl.report_header_id = p_report_header_id
799: AND aerh.report_header_id = aerl.report_header_id
800: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
801: AND nvl(aerl.receipt_required_flag, 'N') = 'Y'
802: AND nvl(aerl.receipt_verified_flag, 'N') = 'N'
803: AND nvl(aerl.policy_shortpay_flag, 'N') = 'N';
804:

Line 831: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED

827: ap_expense_report_headers aerh,
828: ap_credit_card_trxns cct
829: WHERE erl.report_header_id = p_report_header_id
830: AND aerh.report_header_id = erl.report_header_id
831: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
832: AND nvl(erl.receipt_required_flag, 'N') = 'Y'
833: AND nvl(erl.receipt_verified_flag, 'N') = 'N'
834: AND nvl(erl.policy_shortpay_flag, 'N') = 'N'
835: AND erl.credit_card_trx_id = cct.trx_id

Line 1033: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED

1029: FROM ap_expense_report_lines aerl,
1030: ap_expense_report_headers aerh
1031: WHERE aerl.report_header_id = p_report_header_id
1032: AND aerh.report_header_id = aerl.report_header_id
1033: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
1034: AND (nvl(aerl.receipt_required_flag, 'N') = 'Y' OR nvl(aerl.image_receipt_required_flag, 'N') = 'Y')
1035: AND nvl(aerl.receipt_missing_flag, 'N') = 'N'
1036: AND nvl(aerl.receipt_verified_flag, 'N') = 'N';
1037:

Line 1064: nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED)

1060: AND (aerl.itemization_parent_id is null or aerl.itemization_parent_id = -1)
1061: AND aerh.report_header_id = aerl.report_header_id
1062: AND (nvl(aerl.policy_shortpay_flag,'N') = 'Y'
1063: OR ( ((nvl(aerl.receipt_required_flag, 'N') = 'Y' AND
1064: nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED)
1065: OR (nvl(aerl.image_receipt_required_flag, 'N') = 'Y' AND
1066: nvl(aerh.image_receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED))
1067: AND nvl(aerl.receipt_verified_flag, 'N') = 'N'
1068: )

Line 1066: nvl(aerh.image_receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED))

1062: AND (nvl(aerl.policy_shortpay_flag,'N') = 'Y'
1063: OR ( ((nvl(aerl.receipt_required_flag, 'N') = 'Y' AND
1064: nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED)
1065: OR (nvl(aerl.image_receipt_required_flag, 'N') = 'Y' AND
1066: nvl(aerh.image_receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED))
1067: AND nvl(aerl.receipt_verified_flag, 'N') = 'N'
1068: )
1069: );
1070: