DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_PRC_CONTEXTS_TL

Line 521: FROM qp_prc_contexts_b b, qp_prc_contexts_tl t

517:
518: CURSOR contexts_cur(a_context_code VARCHAR2, a_context_type VARCHAR2)
519: IS
520: SELECT nvl(t.user_prc_context_name, t.seeded_prc_context_name), b.enabled_flag
521: FROM qp_prc_contexts_b b, qp_prc_contexts_tl t
522: WHERE b.prc_context_id = t.prc_context_id
523: AND t.language = userenv('LANG')
524: AND b.prc_context_code = a_context_code
525: AND b.prc_context_type = a_context_type;

Line 4323: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b

4319: SELECT a.prc_context_code,
4320: nvl(b.user_prc_context_name, b.seeded_prc_context_name)
4321: prc_context_name,
4322: a.enabled_flag, a.prc_context_type
4323: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b
4324: WHERE a.prc_context_id = b.prc_context_id
4325: AND b.language = userenv('LANG')
4326: AND EXISTS (SELECT 'x'
4327: FROM qp_segments_b c, qp_pte_segments d