DBA Data[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PA_EXPENDITURE_TYPES_EXPEND_V

Line 15612: FROM pa_expenditure_types_expend_v

15608: END;
15609: BEGIN
15610: SELECT 'x'
15611: INTO l_check
15612: FROM pa_expenditure_types_expend_v
15613: WHERE system_linkage_function='VI'
15614: AND (sysdate between expnd_typ_start_date_active and nvl(expnd_typ_end_date_active, sysdate))
15615: AND (sysdate between sys_link_start_date_active and nvl(sys_link_end_date_active,sysdate))
15616: AND trim(expenditure_type) = trim(p_payment_terms_tbl(i).expenditure_type);