APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_EVENTS

Line 156: /* from pa_events_v ev Commented for performance bug 2706550 */

152: select 'Events not processed' , 'PA_ARPR_NOT_ENVT_PCSD'
153: from dual
154: where exists
155: ( select 'x'
156: /* from pa_events_v ev Commented for performance bug 2706550 */
157: from pa_events ev /* Added for performance bug 2706550 */
158: where ev.project_id = p_project_id
159: and NVL(ev.revenue_distributed_flag,'N') <> 'Y'
160: and NVL(ev.bill_trans_REV_AMOUNT,0) > 0

Line 157: from pa_events ev /* Added for performance bug 2706550 */

153: from dual
154: where exists
155: ( select 'x'
156: /* from pa_events_v ev Commented for performance bug 2706550 */
157: from pa_events ev /* Added for performance bug 2706550 */
158: where ev.project_id = p_project_id
159: and NVL(ev.revenue_distributed_flag,'N') <> 'Y'
160: and NVL(ev.bill_trans_REV_AMOUNT,0) > 0
161: UNION

Line 163: /* from pa_events_v ey, Commented for performance bug 2706550 */

159: and NVL(ev.revenue_distributed_flag,'N') <> 'Y'
160: and NVL(ev.bill_trans_REV_AMOUNT,0) > 0
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

Line 164: from pa_events ey, /* Added for performance bug 2706550 */

160: and NVL(ev.bill_trans_REV_AMOUNT,0) > 0
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'