APPS.PA_EVENT_CORE dependencies on PA_EVENT_TYPES

Line 233: l_event_type_classification PA_EVENT_TYPES.EVENT_TYPE_CLASSIFICATION %TYPE;

229: P_event_type IN VARCHAR2
230: ,P_context IN VARCHAR2
231: ,P_event_type_classification OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS --File.Sql.39 bug 4440895
232:
233: l_event_type_classification PA_EVENT_TYPES.EVENT_TYPE_CLASSIFICATION %TYPE;
234:
235: CURSOR valid_event
236: IS
237: SELECT event_type_classification

Line 238: FROM pa_event_types_lov_v

234:
235: CURSOR valid_event
236: IS
237: SELECT event_type_classification
238: FROM pa_event_types_lov_v
239: WHERE event_type=P_event_type;
240:
241: CURSOR valid_delv_event
242: IS

Line 244: FROM pa_event_types_lov_v

240:
241: CURSOR valid_delv_event
242: IS
243: SELECT event_type_classification
244: FROM pa_event_types_lov_v
245: WHERE event_type=P_event_type
246: AND event_type_classification = 'MANUAL';
247:
248: BEGIN

Line 920: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT

916: CURSOR proj_write_off_amount
917: IS
918: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
919: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
920: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT
921: WHERE EVT.event_type_classification='WRITE OFF'
922: AND EVT.event_type=EV.event_type
923: AND NVL(EV.revenue_distributed_flag,'N')='N'
924: AND EV.completion_date IS NOT NULL

Line 936: AND exists (select 1 from PA_EVENT_TYPES EVT

932: FROM PA_EVENTS EV
933: WHERE EV.revenue_distributed_flag ='N'
934: AND EV.completion_date IS NOT NULL
935: AND NVL(EV.event_id,-1)<>NVL(P_event_id,-2)
936: AND exists (select 1 from PA_EVENT_TYPES EVT
937: where EVT.event_type_classification='WRITE OFF'
938: and EVT.event_type=EV.event_type )
939: AND EV.project_id= P_project_id;
940:

Line 945: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT

941: CURSOR task_write_off_amount
942: IS
943: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
944: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
945: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT
946: WHERE EVT.event_type_classification='WRITE OFF'
947: AND EVT.event_type=EV.event_type
948: AND NVL(EV.revenue_distributed_flag,'N')='N'
949: AND EV.completion_date IS NOT NULL