DBA Data[Home] [Help]

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on PA_PROJECTS_ALL

Line 245: FROM jai_pa_draft_invoices a, ra_interface_lines_all b, pa_projects_all c

241: --added for bug#9151886
242: CURSOR c_get_orgn_project
243: IS
244: SELECT a.organization_id, a.location_id
245: FROM jai_pa_draft_invoices a, ra_interface_lines_all b, pa_projects_all c
246: WHERE b.interface_line_context = 'PROJECTS INVOICES'
247: AND b.line_type = 'LINE'
248: AND b.interface_line_attribute1 = c.segment1
249: AND c.project_id = a.project_id