34:
35: ------------------------
36: -- Expense Report Sources
37: ------------------------
38: C_SELF_SERVICE_SOURCE CONSTANT ap_expense_report_headers.source%type := 'SelfService';
39: C_BOTHPAY CONSTANT ap_expense_report_headers.source%type := 'Both Pay';
40:
41: ------------------------
42: -- Expense Report Statuses
35: ------------------------
36: -- Expense Report Sources
37: ------------------------
38: C_SELF_SERVICE_SOURCE CONSTANT ap_expense_report_headers.source%type := 'SelfService';
39: C_BOTHPAY CONSTANT ap_expense_report_headers.source%type := 'Both Pay';
40:
41: ------------------------
42: -- Expense Report Statuses
43: ------------------------
40:
41: ------------------------
42: -- Expense Report Statuses
43: ------------------------
44: C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45: C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46: C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47: C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48: C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
41: ------------------------
42: -- Expense Report Statuses
43: ------------------------
44: C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45: C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46: C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47: C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48: C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
49:
42: -- Expense Report Statuses
43: ------------------------
44: C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45: C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46: C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47: C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48: C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
49:
50: ------------------------
43: ------------------------
44: C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45: C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46: C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47: C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48: C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
49:
50: ------------------------
51: -- Lookup: RECEIPTS STATUS
44: C_INVOICED CONSTANT ap_expense_report_headers.expense_status_code%type := 'INVOICED';
45: C_PARPAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PARPAID';
46: C_PAID CONSTANT ap_expense_report_headers.expense_status_code%type := 'PAID';
47: C_PENDING_HOLDS CONSTANT ap_expense_report_headers.expense_status_code%type := 'PEND_HOLDS_CLEARANCE';
48: C_PAYMENT_HELD CONSTANT ap_expense_report_headers.expense_status_code%type := 'HOLD_PENDING_RECEIPTS';
49:
50: ------------------------
51: -- Lookup: RECEIPTS STATUS
52: ------------------------