DBA Data[Home] [Help]

APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_PROJECTS_ALL

Line 258: from pa_draft_revenues_all dr, pa_projects_all pa

254: dr.gl_date) gl_period_name ,
255: dr.unbilled_receivable_dr ubr_amount,
256: dr.unearned_revenue_cr uer_amount,
257: 'U' ins_upd_flag
258: from pa_draft_revenues_all dr, pa_projects_all pa
259: where pa.org_id = G_org_id
260: and dr.project_id = pa.project_id
261: and dr.transfer_status_code = 'A'
262: and dr.gl_date <= G_p_gl_end_date

Line 622: from pa_draft_invoices_all di, pa_projects_all pa

618: di.gl_date) gl_period_name ,
619: di.unbilled_receivable_dr ubr_amount,
620: di.unearned_revenue_cr uer_amount,
621: 'U' ins_upd_flag
622: from pa_draft_invoices_all di, pa_projects_all pa
623: where pa.org_id = G_org_id
624: and di.project_id = pa.project_id
625: and di.transfer_status_code = 'A'
626: and di.gl_date <= G_p_gl_end_date