APPS.AP_CARD_INVOICE_PKG dependencies on AP_EXPENSE_FEED_LINES

Line 14: -- o AP_EXPENSE_FEED_LINES.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

10: -- for payment of records in AP_EXPENSE_FEED_DISTS.
11: --
12: -- Records inserted into AP_INVOICE_LINES_INTERFACE from
13: -- AP_EXPENSE_FEED_DISTS where
14: -- o AP_EXPENSE_FEED_LINES.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
15: -- o AP_EXPENSE_FEED_DISTS.TRANSACTION_DATE between
16: -- P_START_DATE and P_END_DATE.
17: -- o AP_EXPENSE_FEED_DISTS.STATUS = 'APPROVED' or status is
18: -- not excepted from payment as defined at the card program

Line 79: from ap_expense_feed_lines efl,

75: efd.attribute12,
76: efd.attribute13,
77: efd.attribute14,
78: efd.attribute15
79: from ap_expense_feed_lines efl,
80: ap_expense_feed_dists efd,
81: ap_card_programs cp
82: where efl.feed_line_id = efd.feed_line_id
83: and efl.card_program_id = P_CARD_PROGRAM_ID

Line 157: /*l_merchant_name AP_EXPENSE_FEED_LINES.merchant_name%TYPE;

153: l_vendor_site_id number;
154: l_org_id number; -- Bug 5592139
155: l_debug_info VARCHAR2(100);
156: --Commenting unnecessary variables 14457995.
157: /*l_merchant_name AP_EXPENSE_FEED_LINES.merchant_name%TYPE;
158: l_merchant_number AP_EXPENSE_FEED_LINES.merchant_number%TYPE; --bug8299023 */
159: l_period_name ap_invoice_distributions.period_name%TYPE; --Bug 10218303
160: l_gl_date ap_invoices.gl_date%TYPE; --Bug 10218303
161: rec_lines_int lines_cursor%ROWTYPE; /*Bug 14457995*/

Line 158: l_merchant_number AP_EXPENSE_FEED_LINES.merchant_number%TYPE; --bug8299023 */

154: l_org_id number; -- Bug 5592139
155: l_debug_info VARCHAR2(100);
156: --Commenting unnecessary variables 14457995.
157: /*l_merchant_name AP_EXPENSE_FEED_LINES.merchant_name%TYPE;
158: l_merchant_number AP_EXPENSE_FEED_LINES.merchant_number%TYPE; --bug8299023 */
159: l_period_name ap_invoice_distributions.period_name%TYPE; --Bug 10218303
160: l_gl_date ap_invoices.gl_date%TYPE; --Bug 10218303
161: rec_lines_int lines_cursor%ROWTYPE; /*Bug 14457995*/
162:

Line 351: from AP_EXPENSE_FEED_LINES EFL,

347: and nvl(efd.tax_code,'N')= nvl(rec_lines_int.tax_code,'N') --9727870
348: and nvl(efd.amount_includes_tax_flag,'N')= rec_lines_int.amount_includes_tax_flag --9727870
349: and exists
350: (select 'Parent record meets group criteria from lines_cursor'
351: from AP_EXPENSE_FEED_LINES EFL,
352: AP_CARD_PROGRAMS CP
353: where EFL.feed_line_id = EFD.feed_line_id
354: and EFL.card_program_id = P_CARD_PROGRAM_ID
355: and EFL.card_program_id = CP.card_program_id