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:
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:

Line 1100: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,

1096: END SendDunningNotifications;
1097:
1098:
1099: PROCEDURE sendUnapprovedExpReportNote(
1100: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1101: p_current_approver IN AP_EXPENSE_REPORT_HEADERS.expense_current_approver_id%TYPE) --2628468
1102:
1103: IS
1104: l_itemType VARCHAR2(100) := 'APCCARD';

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

1097:
1098:
1099: PROCEDURE sendUnapprovedExpReportNote(
1100: p_expenseReportId IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE,
1101: p_current_approver IN AP_EXPENSE_REPORT_HEADERS.expense_current_approver_id%TYPE) --2628468
1102:
1103: IS
1104: l_itemType VARCHAR2(100) := 'APCCARD';
1105: l_itemKey VARCHAR2(100);