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 61: from ap_expense_feed_lines efl,

57: nvl(P_START_DATE,nvl(P_END_DATE,sysdate))),
58: decode(P_ROLLUP_FLAG,
59: 'N',efd.description),
60: efd.org_id -- Bug 5592139
61: from ap_expense_feed_lines efl,
62: ap_expense_feed_dists efd,
63: ap_card_programs cp
64: where efl.feed_line_id = efd.feed_line_id
65: and efl.card_program_id = P_CARD_PROGRAM_ID

Line 237: from AP_EXPENSE_FEED_LINES EFL,

233: where nvl(invoiced_flag,'N') = 'N'
234: and dist_code_combination_id = l_ccid
235: and exists
236: (select 'Parent record meets group criteria from lines_cursor'
237: from AP_EXPENSE_FEED_LINES EFL,
238: AP_CARD_PROGRAMS CP
239: where EFL.feed_line_id = EFD.feed_line_id
240: and EFL.card_program_id = P_CARD_PROGRAM_ID
241: and EFL.card_program_id = CP.card_program_id