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 900: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT

896: CURSOR proj_write_off_amount
897: IS
898: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
899: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
900: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT
901: WHERE EVT.event_type_classification='WRITE OFF'
902: AND EVT.event_type=EV.event_type
903: AND NVL(EV.revenue_distributed_flag,'N')='N'
904: AND EV.completion_date IS NOT NULL

Line 916: AND exists (select 1 from PA_EVENT_TYPES EVT

912: FROM PA_EVENTS EV
913: WHERE EV.revenue_distributed_flag ='N'
914: AND EV.completion_date IS NOT NULL
915: AND NVL(EV.event_id,-1)<>NVL(P_event_id,-2)
916: AND exists (select 1 from PA_EVENT_TYPES EVT
917: where EVT.event_type_classification='WRITE OFF'
918: and EVT.event_type=EV.event_type )
919: AND EV.project_id= P_project_id;
920:

Line 925: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT

921: CURSOR task_write_off_amount
922: IS
923: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
924: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
925: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT
926: WHERE EVT.event_type_classification='WRITE OFF'
927: AND EVT.event_type=EV.event_type
928: AND NVL(EV.revenue_distributed_flag,'N')='N'
929: AND EV.completion_date IS NOT NULL