APPS.PQH_TCA_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 327: from pqh_transaction_categories

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
327: from pqh_transaction_categories
328: where short_name = p_tran_cat_short_name
329: and business_group_id is null;
330: --
331: cursor csr_txn_cat_att_id ( p_attribute_id IN NUMBER, p_txn_category_id IN NUMBER ) is

Line 345: from pqh_transaction_categories

341: --
342: --
343: Cursor csr_local_txn_cat_id is
344: select transaction_category_id
345: from pqh_transaction_categories
346: where short_name = p_tran_cat_short_name
347: and business_group_id is not null;
348: --
349: --

Line 458: from pqh_transaction_categories

454: WHERE attribute_id = l_attribute_id
455: -- AND NVL(last_updated_by,-1) in (1,-1);
456: AND transaction_category_id in (
457: select transaction_category_id
458: from pqh_transaction_categories
459: where short_name = p_tran_cat_short_name
460: and business_group_id is not null);
461: End if; -- Propogate changes to bg specific txn category attributes
462:

Line 482: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_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(
483: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
484: p_ref_type=>'INS');
485:
486: --

Line 550: PER_RIC_PKG.ref_info_rec('PQH_TRANSACTION_CATEGORIES',PER_RIC_PKG.column_info_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(
551: PER_RIC_PKG.col_info_rec('TRANSACTION_CATEGORY_ID',NULL,l_transaction_category_id, NULL)))),
552: p_ref_type=>'INS');
553: --
554: -- Code Ends Here