APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

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: