DBA Data[Home] [Help]

APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_PROJECTS_ALL

Line 260: from pa_draft_revenues_all dr, pa_projects_all pa

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

Line 624: from pa_draft_invoices_all di, pa_projects_all pa

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