APPS.PQH_TCT_WIZARD_PKG dependencies on PQH_ROUTING_CATEGORIES_V

Line 2803: from pqh_routing_categories_v

2799: --
2800: Cursor csr_def_hier (p_transaction_category_id in number,
2801: p_member_cd in varchar2) is
2802: Select routing_category_id
2803: from pqh_routing_categories_v
2804: where member_cd = p_member_cd
2805: and transaction_category_id = p_transaction_category_id
2806: and nvl(enable_flag,'Y') = 'Y'
2807: and nvl(default_flag,'N') = 'Y';

Line 3618: from pqh_routing_categories_v a

3614: --
3615: Cursor csr_hier (p_transaction_category_id in number,
3616: p_member_cd in varchar2) is
3617: Select routing_category_id
3618: from pqh_routing_categories_v a
3619: where a.transaction_category_id = p_transaction_category_id
3620: and a.member_cd = p_member_cd
3621: and nvl(a.enable_flag,'Y') = 'Y'
3622: and nvl(a.delete_flag,'N') <> 'Y'