APPS.PQH_TCT_WIZARD_PKG dependencies on PQH_ROUTING_CATEGORIES_V

Line 2782: from pqh_routing_categories_v

2778: --
2779: Cursor csr_def_hier (p_transaction_category_id in number,
2780: p_member_cd in varchar2) is
2781: Select routing_category_id
2782: from pqh_routing_categories_v
2783: where member_cd = p_member_cd
2784: and transaction_category_id = p_transaction_category_id
2785: and nvl(enable_flag,'Y') = 'Y'
2786: and nvl(default_flag,'N') = 'Y';

Line 3597: from pqh_routing_categories_v a

3593: --
3594: Cursor csr_hier (p_transaction_category_id in number,
3595: p_member_cd in varchar2) is
3596: Select routing_category_id
3597: from pqh_routing_categories_v a
3598: where a.transaction_category_id = p_transaction_category_id
3599: and a.member_cd = p_member_cd
3600: and nvl(a.enable_flag,'Y') = 'Y'
3601: and nvl(a.delete_flag,'N') <> 'Y'