APPS.PA_MCB_REVENUE_PKG dependencies on PA_EVENT_TYPES

Line 111: FROM pa_event_types vt

107: DECODE(NVL(v.zero_revenue_amount_flag, 'N'), 'Y', 1, 0),1) = 1)
108: AND v.calling_place = p_calling_place
109: AND EXISTS
110: (SELECT vt.event_type
111: FROM pa_event_types vt
112: WHERE vt.event_type = v.event_type
113: AND vt.event_type_classification||''= 'AUTOMATIC'
114: )
115: AND ( v.calling_process||'' = 'Revenue'

Line 148: pa_event_types vt

144: revproc_exchange_rate,
145: DECODE(vt.event_type_classification , 'REALIZED_GAINS', 'Y',
146: 'REALIZED_LOSSES', 'Y','N')
147: FROM pa_events evt,
148: pa_event_types vt
149: WHERE evt.project_id = p_project_id
150: AND evt.request_id = p_request_id
151: AND evt.revenue_distributed_flag = 'D'
152: AND TRUNC(evt.completion_date) <= TRUNC(NVL(p_acc_thru_dt,sysdate)) /* Bug#3118592 */

Line 165: FROM pa_event_types vt

161: AND tsk.task_id = NVL( evt.task_id, tsk.task_id )
162: AND tsk.ready_to_distribute_flag ||'' = 'Y'
163: )
164: /* AND EXISTS ( SELECT 'Write on or Write off or Manual events exists'
165: FROM pa_event_types vt
166: WHERE vt.event_type = evt.event_type ||''
167: AND vt.event_type_classification ||'' IN
168: ('WRITE ON','WRITE OFF','MANUAL','REALIZED_GAINS','REALIZED_LOSSES')
169: ) */