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:
108: BEGIN
109:
110: ------------------------------------------------------------

Line 156: FROM ap_expense_report_headers_all aerh1,

152:
153: BEGIN
154: SELECT aerh2.invoice_num
155: INTO l_invoiceNum
156: FROM ap_expense_report_headers_all aerh1,
157: ap_expense_report_headers_all aerh2
158: WHERE aerh1.bothpay_parent_id = aerh2.report_header_id
159: AND aerh1.invoice_num = p_invoiceNumber
160: AND aerh1.source = 'Both Pay';

Line 157: ap_expense_report_headers_all aerh2

153: BEGIN
154: SELECT aerh2.invoice_num
155: INTO l_invoiceNum
156: FROM ap_expense_report_headers_all aerh1,
157: ap_expense_report_headers_all aerh2
158: WHERE aerh1.bothpay_parent_id = aerh2.report_header_id
159: AND aerh1.invoice_num = p_invoiceNumber
160: AND aerh1.source = 'Both Pay';
161: