DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 343: Select 'x' from pa_expenditure_types_expend_v et

339: Select 'x' from gl_daily_conversion_types
340: where conversion_type= p_exchange_rate_type;
341:
342: Cursor c_check_expend_type IS
343: Select 'x' from pa_expenditure_types_expend_v et
344: where system_linkage_function = 'VI'
345: and et.project_id = (select project_id from oke_deliverables_b
346: where deliverable_id=p_deliverable_id)
347: and expenditure_type = p_expenditure_type

Line 349: select 'x' from pa_expenditure_types_expend_v et

345: and et.project_id = (select project_id from oke_deliverables_b
346: where deliverable_id=p_deliverable_id)
347: and expenditure_type = p_expenditure_type
348: union
349: select 'x' from pa_expenditure_types_expend_v et
350: where system_linkage_function = 'VI'
351: and et.project_id is null
352: and expenditure_type = p_expenditure_type;
353: