APPS.PATC dependencies on PA_EXPENDITURE_TYPES

Line 279: FROM pa_expenditure_types

275: /** Bug fix :2345895 End **/
276: AND ( tc.expenditure_category IS NULL
277: OR tc.expenditure_category =
278: ( SELECT expenditure_category
279: FROM pa_expenditure_types
280: WHERE expenditure_type = X_expenditure_type ) )
281: AND ( tc.expenditure_type IS NULL
282: OR tc.expenditure_type = X_expenditure_type )
283: AND ( tc.non_labor_resource IS NULL

Line 391: , pa_expenditure_types et

387: FROM dual
388: WHERE NOT EXISTS
389: ( SELECT 1
390: FROM pa_expend_typ_sys_links etsl
391: , pa_expenditure_types et
392: WHERE etsl.expenditure_type = et.expenditure_type
393: AND etsl.expenditure_type = X_expenditure_type
394: AND etsl.system_linkage_function = 'VI'
395: AND et.cost_rate_flag = 'Y' );

Line 416: FROM pa_expenditure_types et

412: BEGIN
413: SELECT count(1)
414:
415: INTO dummy
416: FROM pa_expenditure_types et
417: WHERE et.expenditure_type = X_expenditure_type
418: AND X_ei_date BETWEEN et.start_date_active AND
419: nvl( et.end_date_active, X_ei_date ) ;
420:

Line 750: , pa_expenditure_types et

746: FROM dual
747: WHERE EXISTS
748: ( SELECT 1
749: FROM pa_expend_typ_sys_links etsl
750: , pa_expenditure_types et
751: WHERE etsl.expenditure_type = et.expenditure_type
752: AND etsl.expenditure_type = X_expenditure_type
753: AND etsl.system_linkage_function = 'VI'
754: );