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 4346: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b

4342: SELECT a.prc_context_code,
4343: nvl(b.user_prc_context_name, b.seeded_prc_context_name)
4344: prc_context_name,
4345: a.enabled_flag, a.prc_context_type
4346: FROM qp_prc_contexts_b a, qp_prc_contexts_tl b
4347: WHERE a.prc_context_id = b.prc_context_id
4348: AND b.language = userenv('LANG')
4349: AND EXISTS (SELECT 'x'
4350: FROM qp_segments_b c, qp_pte_segments d