APPS.PATC dependencies on PA_EXPENDITURE_TYPES

Line 248: FROM pa_expenditure_types

244: /** Bug fix :2345895 End **/
245: AND ( tc.expenditure_category IS NULL
246: OR tc.expenditure_category =
247: ( SELECT expenditure_category
248: FROM pa_expenditure_types
249: WHERE expenditure_type = X_expenditure_type ) )
250: AND ( tc.expenditure_type IS NULL
251: OR tc.expenditure_type = X_expenditure_type )
252: AND ( tc.non_labor_resource IS NULL

Line 358: , pa_expenditure_types et

354: FROM dual
355: WHERE NOT EXISTS
356: ( SELECT 1
357: FROM pa_expend_typ_sys_links etsl
358: , pa_expenditure_types et
359: WHERE etsl.expenditure_type = et.expenditure_type
360: AND etsl.expenditure_type = X_expenditure_type
361: AND etsl.system_linkage_function = 'VI'
362: AND et.cost_rate_flag = 'Y' );

Line 383: FROM pa_expenditure_types et

379: BEGIN
380: SELECT count(1)
381:
382: INTO dummy
383: FROM pa_expenditure_types et
384: WHERE et.expenditure_type = X_expenditure_type
385: AND X_ei_date BETWEEN et.start_date_active AND
386: nvl( et.end_date_active, X_ei_date ) ;
387:

Line 696: , pa_expenditure_types et

692: FROM dual
693: WHERE EXISTS
694: ( SELECT 1
695: FROM pa_expend_typ_sys_links etsl
696: , pa_expenditure_types et
697: WHERE etsl.expenditure_type = et.expenditure_type
698: AND etsl.expenditure_type = X_expenditure_type
699: AND etsl.system_linkage_function = 'VI'
700: );