DBA Data[Home] [Help]

APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 797: FROM pa_expenditure_types_expend_v exptype

793: )
794: WHEN line_origination_code <> 'REQUISITION'
795: AND project_expenditure_type IS NOT NULL
796: AND NOT EXISTS (SELECT 1
797: FROM pa_expenditure_types_expend_v exptype
798: WHERE system_linkage_function = 'VI'
799: AND exptype.expenditure_type = project_expenditure_type
800: AND trunc(sysdate) BETWEEN nvl(exptype.expnd_typ_start_date_active, trunc(sysdate))
801: AND nvl(exptype.expnd_typ_end_date_Active, trunc(sysdate))