DBA Data[Home] [Help]

APPS.CSF_UTIL_PVT dependencies on CSF_DC_QUERIES_B

Line 557: l_where csf_dc_queries_b.where_clause%TYPE;

553: END get_qualifier_table;
554:
555: FUNCTION get_query_where(p_query_id NUMBER)
556: RETURN VARCHAR2 IS
557: l_where csf_dc_queries_b.where_clause%TYPE;
558: l_enabled_flag VARCHAR2(1);
559: l_owner_id NUMBER;
560: l_owner_type VARCHAR2(30);
561:

Line 569: FROM csf_dc_queries_b q

565: , ( SELECT COUNT(*)
566: FROM csf_plan_task_owners
567: WHERE user_id = fnd_global.user_id
568: ) owners_count
569: FROM csf_dc_queries_b q
570: , csf_dc_query_extns qe
571: WHERE q.query_id = p_query_id
572: AND qe.user_id(+) = fnd_global.user_id
573: AND qe.query_id(+) = q.query_id;