APPS.PQH_TCT_SHD dependencies on PQH_TABLE_ROUTE

Line 423: From pqh_table_route

419: cursor c1 is select userenv('LANG') from dual ;
420: --
421: Cursor c2(p_table_alias in VARCHAR2) is
422: Select table_route_id
423: From pqh_table_route
424: Where table_alias = p_table_alias;
425: --
426: --
427: Cursor c3 is

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

586: PER_RIC_PKG.chk_integrity (
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');

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

588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),
592: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
593: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_master_table_route_id, NULL)))),
594: p_ref_type=>'INS');
595: --
596: -- Code Ends Here