DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on FA_CATEGORIES_B

Line 23055: FROM FA_CATEGORIES_B

23051: p_segment5 VARCHAR2,
23052: p_segment6 VARCHAR2,
23053: p_segment7 VARCHAR2 ) IS
23054: SELECT category_id
23055: FROM FA_CATEGORIES_B
23056: WHERE (segment1 = NVL(p_segment1,'NULL') OR segment1 IS NULL)
23057: AND (segment2 = NVL(p_segment2,'NULL') OR segment2 is NULL)
23058: AND (segment3 = NVL(p_segment3,'NULL') OR segment3 IS NULL)
23059: AND (segment4 = NVL(p_segment4,'NULL') OR segment4 IS NULL)