1854: al.expenditure_type exp_type,
1855: hr.name exp_org,
1856: al.amount
1857: from AP_INVOICE_LINES_INTERFACE al
1858: , ap_interface_rejections ar,
1859: AP_INVOICES_INTERFACE ad,
1860: pa_tasks pta,hr_organization_units hr,
1861: fnd_lookup_values lookup
1862: where ar.parent_id=al.invoice_line_id
1873:
1874:
1875: CURSOR C5 IS
1876: select lookup.description reason
1877: from ap_interface_rejections ar,
1878: AP_INVOICES_INTERFACE ad,
1879: fnd_lookup_values lookup
1880: where ar.parent_id=ad.invoice_id
1881: and ar.parent_table='AP_INVOICES_INTERFACE'