DBA Data[Home] [Help]

APPS.OKL_RULE_PUB dependencies on JTF_OBJECTS_VL

Line 3918: FROM JTF_OBJECTS_VL

3914: '(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
3915: ||from_table select_clause
3916: -- ||decode(p_clause_yn,'Y',decode(where_clause,'','',' where '||where_clause))|| ')'
3917: ,where_clause
3918: FROM JTF_OBJECTS_VL
3919: WHERE object_code = p_object_code;
3920: l_sql varchar2(4000);
3921: l_where varchar2(4000);
3922: begin

Line 3955: FROM JTF_OBJECTS_VL

3951: '(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
3952: ||from_table||decode(where_clause,
3953: '',' where status = ''A'' and party_id = '''||l1||'''',
3954: ' where status = ''A'' and party_id = '''||l1||''' and '||where_clause)|| ')'
3955: FROM JTF_OBJECTS_VL
3956: WHERE object_code = p_object_code;
3957: l_sql varchar2(4000);
3958: begin
3959: if (p_object_code is NULL) then return