APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_EXPENSE_REPORT_HEADERS

Line 106: l_invoiceNum AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;

102: l_employeeDisplayName wf_users.display_name%type;
103: l_threshold number := wf_engine.threshold;
104: l_debugInfo VARCHAR2(200);
105: l_account IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := NULL;
106: l_invoiceNum AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;
107: l_process_created VARCHAR2(1);
108:
109: BEGIN
110:

Line 164: FROM ap_expense_report_headers_all aerh1,

160:
161: BEGIN
162: SELECT aerh2.invoice_num
163: INTO l_invoiceNum
164: FROM ap_expense_report_headers_all aerh1,
165: ap_expense_report_headers_all aerh2
166: WHERE aerh1.bothpay_parent_id = aerh2.report_header_id
167: AND aerh1.invoice_num = p_invoiceNumber
168: AND aerh1.source = 'Both Pay';

Line 165: ap_expense_report_headers_all aerh2

161: BEGIN
162: SELECT aerh2.invoice_num
163: INTO l_invoiceNum
164: FROM ap_expense_report_headers_all aerh1,
165: ap_expense_report_headers_all aerh2
166: WHERE aerh1.bothpay_parent_id = aerh2.report_header_id
167: AND aerh1.invoice_num = p_invoiceNumber
168: AND aerh1.source = 'Both Pay';
169:

Line 1168: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1164: END SendDunningNotifications;
1165:
1166:
1167: PROCEDURE sendUnapprovedExpReportNote(
1168: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1169: p_current_approver IN AP_EXPENSE_REPORT_HEADERS.expense_current_approver_id%TYPE) --2628468
1170:
1171: IS
1172: l_itemType VARCHAR2(100) := 'APCCARD';

Line 1169: p_current_approver IN AP_EXPENSE_REPORT_HEADERS.expense_current_approver_id%TYPE) --2628468

1165:
1166:
1167: PROCEDURE sendUnapprovedExpReportNote(
1168: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1169: p_current_approver IN AP_EXPENSE_REPORT_HEADERS.expense_current_approver_id%TYPE) --2628468
1170:
1171: IS
1172: l_itemType VARCHAR2(100) := 'APCCARD';
1173: l_itemKey VARCHAR2(100);