DBA Data[Home] [Help]

APPS.OKC_RUL_PVT dependencies on JTF_OBJECTS_VL

Line 1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;

1263: sql_stmt VARCHAR2(4000);
1264: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1268: l_where_clause varchar2(4000);
1269: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1270: TYPE l_info_type IS REF CURSOR;
1271: l_info_csr l_info_type;

Line 1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;

1609: sql_stmt VARCHAR2(4000);
1610: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1614: l_where_clause varchar2(4000);
1615: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1616: CURSOR l_jtot_csr IS
1617: SELECT decode(where_clause,'','','and '||where_clause) where_clause,