DBA Data[Home] [Help]

APPS.PA_DEDUCTIONS dependencies on HR_ORGANIZATION_UNITS

Line 1845: ,po_vendors v, po_vendor_sites_all vs,hr_organization_units hr

1841: ,v.vendor_name
1842: ,vs.vendor_site_code
1843: ,hr.name hr_name
1844: from pa_deductions_all pded,pa_projects_all pa
1845: ,po_vendors v, po_vendor_sites_all vs,hr_organization_units hr
1846: where pa.project_id=pded.project_id and
1847: pded.vendor_id= v.vendor_id and pded.vendor_site_id=vs.vendor_site_id
1848: and pa.org_id=hr.organization_id
1849: and pded.deduction_req_id = p_dctn_req_id;

Line 1860: pa_tasks pta,hr_organization_units hr,

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
1863: and ar.parent_table='AP_INVOICE_LINES_INTERFACE'
1864: and al.invoice_id=ad.invoice_id