DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_EVENT_TYPES

Line 165: pa_event_types et

161: UNION
162: select 'x'
163: /* from pa_events_v ey, Commented for performance bug 2706550 */
164: from pa_events ey, /* Added for performance bug 2706550 */
165: pa_event_types et
166: where ey.project_id = p_project_id
167: and et.event_type = ey.event_type
168: and NVL(ey.bill_hold_flag,'N') = 'N'
169: and NVL(ey.bill_trans_bill_amount,0) <> 0