DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 1127: FROM pa_expenditure_types_expend_v exptype

1123: SYSDATE, l_loginid -- 6
1124: )
1125: WHEN s_project_exp_type IS NOT NULL
1126: AND NOT EXISTS (SELECT 1
1127: FROM pa_expenditure_types_expend_v exptype
1128: WHERE system_linkage_function = 'VI'
1129: AND exptype.expenditure_type = s_project_exp_type
1130: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
1131: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))