353: INTO dummy
354: FROM dual
355: WHERE NOT EXISTS
356: ( SELECT 1
357: FROM pa_expend_typ_sys_links etsl
358: , pa_expenditure_types et
359: WHERE etsl.expenditure_type = et.expenditure_type
360: AND etsl.expenditure_type = X_expenditure_type
361: AND etsl.system_linkage_function = 'VI'
547: INTO
548: G_EXP_TYPE_SYS_LINK
549: ,G_EXP_TYPE_START_DATE
550: ,G_EXP_TYPE_END_DATE
551: FROM pa_expend_typ_sys_links
552: WHERE system_linkage_function = X_system_linkage
553: AND expenditure_type = X_etype ;
554:
555:
691: INTO dummy
692: FROM dual
693: WHERE EXISTS
694: ( SELECT 1
695: FROM pa_expend_typ_sys_links etsl
696: , pa_expenditure_types et
697: WHERE etsl.expenditure_type = et.expenditure_type
698: AND etsl.expenditure_type = X_expenditure_type
699: AND etsl.system_linkage_function = 'VI'