DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 1174: FROM pa_expenditure_types_expend_v exptype

1170: )
1171: WHEN S_CLM_INFO_FLAG = 'N' AND
1172: s_project_exp_type IS NOT NULL
1173: AND NOT EXISTS (SELECT 1
1174: FROM pa_expenditure_types_expend_v exptype
1175: WHERE system_linkage_function = 'VI'
1176: AND exptype.expenditure_type = s_project_exp_type
1177: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
1178: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))