DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_DRAFT_REVENUES

Line 92: from pa_draft_revenues dr,

88: /* Deleted the old code and added below for bug # 2861315 */
89: select 'Revenue Not Transferred and Accepted ' , 'PA_ARPR_NOT_REV_IFCD'
90: from dual
91: where exists ( select draft_revenue_num
92: from pa_draft_revenues dr,
93: pa_implementations imp
94: where dr.project_id = p_project_id
95: and (( dr.transfer_status_code <> 'A'
96: and nvl(imp.INTERFACE_REVENUE_TO_GL_FLAG,'N')<>'Y')