DBA Data[Home] [Help]

APPS.PA_MC_RETN_INV_DETAIL_PKG dependencies on PA_PROJECTS_ALL

Line 64: FROM pa_projects_all p, pa_implementations imp,

60: SELECT p.org_id, p.projfunc_currency_code ,
61: imp.set_of_books_id sob,
62: di.invoice_date invoice_date
63: INTO l_org_id, currency, sob, l_invoice_date
64: FROM pa_projects_all p, pa_implementations imp,
65: pa_draft_invoices_all di
66: WHERE di.project_id = p.project_id
67: AND di.draft_invoice_num = p_draft_invoice_num
68: AND p.project_id = p_project_id