DBA Data[Home] [Help]

APPS.GMS_OIE_INT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 332: ap_expense_report_headers_all aerh,

328: null, -- burdenable_raw_cost
329: null, -- rlmi_id
330: null -- bud_task_id
331: from ap_invoice_distributions_all aid,
332: ap_expense_report_headers_all aerh,
333: ap_expense_report_lines_all aerl,
334: gms_project_types gpt,
335: pa_projects_all pp
336: where aerh.vouchno = aid.invoice_id

Line 348: from ap_expense_report_headers_all

344: order by aid.distribution_line_number;
345:
346: cursor get_source(v_invoice_id number) is
347: select source
348: from ap_expense_report_headers_all
349: where vouchno = v_invoice_id;
350:
351: begin
352:

Line 367: from ap_expense_report_headers_all aeh,

363: for i in p_invoice_id.FIRST..p_invoice_id.LAST loop
364:
365: select aeh.report_header_id, aerl.project_id bulk collect
366: into cur_report_header_id, cur_project_id
367: from ap_expense_report_headers_all aeh,
368: ap_expense_report_lines_all aerl,
369: pa_projects_all pp, gms_project_types gpt
370: where aeh.report_header_id = aerl.report_header_id
371: and aeh.vouchno = p_invoice_id(i)