APPS.PQH_TCA_SHD dependencies on PQH_TABLE_ROUTE

Line 322: from pqh_table_route

318: and nvl(legislation_code,'$$$') = nvl(p_legislation_code, '$$$');
319: --
320: cursor csr_table_id (p_table_alias IN VARCHAR2) is
321: select table_route_id
322: from pqh_table_route
323: where table_alias = p_table_alias;
324: --
325: cursor csr_txn_cat_id (p_tran_cat_short_name IN VARCHAR2) is
326: select transaction_category_id

Line 478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

474: PER_RIC_PKG.chk_integrity (
475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
480: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
481: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(

Line 546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(

542: PER_RIC_PKG.chk_integrity (
543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),
548: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
549: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,l_attribute_id, NULL))),
550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_tbl(