APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_WEB_RECEIPT_MANAGEMENT_UTIL

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

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

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

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

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

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

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

1058: AND aerh.report_header_id = aerl.report_header_id
1059: AND (nvl(aerl.policy_shortpay_flag,'N') = 'Y'
1060: OR ( nvl(aerl.receipt_required_flag, 'N') = 'Y'
1061: AND nvl(aerl.receipt_verified_flag, 'N') = 'N'
1062: AND nvl(aerh.receipts_status,'NONE') <> AP_WEB_RECEIPT_MANAGEMENT_UTIL.C_STATUS_WAIVED
1063: )
1064: );
1065:
1066: RETURN true;