[Home] [Help]
109:
110: --
111: cursor txn_cat_c is
112: select transaction_category_id
113: from pqh_transaction_categories
114: where short_name = p_proc_typ_cd ;
115: --
116: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
117: --
112: select transaction_category_id
113: from pqh_transaction_categories
114: where short_name = p_proc_typ_cd ;
115: --
116: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
117: --
118: cursor c_db is select name from v$database ;
119: --
120: l_db_name varchar2(30);
2425: ,cet.information30 source_business_group_name
2426: ,cet.action_date
2427: ,tcg.short_name
2428: from ben_copy_entity_txns_vw cet,
2429: pqh_transaction_categories tcg
2430: where cet.copy_entity_txn_id = c_copy_entity_txn_id
2431: and cet.transaction_category_id = tcg.transaction_category_id;
2432:
2433: cursor c_business_group_name(c_business_group_id in number) is
4821: ,cet.action_date
4822: ,cet.sfl_step_name
4823: ,tcg.short_name
4824: from ben_copy_entity_txns_vw cet,
4825: pqh_transaction_categories tcg
4826: where cet.copy_entity_txn_id = p_copy_entity_txn_id
4827: and cet.transaction_category_id = tcg.transaction_category_id;
4828:
4829: cursor c_chk_selection(c_copy_entity_txn_id in number
5431: 'LogDisabled','N', 'N') log_status
5432: FROM ben_copy_entity_txns_vw cet
5433: WHERE cet.transaction_category_id =
5434: (SELECT ptc.transaction_category_id
5435: FROM PQH_TRANSACTION_CATEGORIES ptc
5436: WHERE ptc.short_name = p_transaction_short_name)
5437: AND cet.copy_entity_txn_id = NVL (p_copy_entity_txn_id, cet.copy_entity_txn_id)
5438: AND cet.status = NVL (p_status, cet.status)
5439: AND cet.src_effective_date <= p_effective_date