APPS.PQH_STR_BUS dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 285: from pqh_txn_category_attributes txnAttrs,

281: is
282: --
283: Cursor csr_validate_criteria IS
284: Select null
285: from pqh_txn_category_attributes txnAttrs,
286: pqh_transaction_categories txnCats
287: where txnAttrs.transaction_category_id = txnCats.transaction_category_id
288: and txnCats.short_name ='FR_PQH_STAT_SIT_TXN'
289: and txn_category_attribute_id = p_txn_category_attribute_id;

Line 320: from pqh_txn_category_attributes

316: where flex_value_set_id = p_value_set_id;
317:
318: Cursor csr_get_value_style IS
319: Select value_style_cd ,value_set_id
320: from pqh_txn_category_attributes
321: where txn_category_attribute_id = p_txn_category_attribute_id;
322: --
323: l_value varchar2(100) := null;
324: l_value_style_cd varchar2(100) := null;

Line 360: from pqh_txn_category_attributes

356: is
357:
358: Cursor csr_get_value_style IS
359: Select value_style_cd
360: from pqh_txn_category_attributes
361: where txn_category_attribute_id = p_txn_category_attribute_id;
362: --
363: l_value_style_cd varchar2(1000);
364: Begin

Line 398: from pqh_txn_category_attributes

394: is
395: --
396: Cursor csr_get_txn_record IS
397: Select value_style_cd
398: from pqh_txn_category_attributes
399: where txn_category_attribute_id = p_txn_category_attribute_id;
400: --
401: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;
402: --

Line 401: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;

397: Select value_style_cd
398: from pqh_txn_category_attributes
399: where txn_category_attribute_id = p_txn_category_attribute_id;
400: --
401: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;
402: --
403: begin
404: --
405: Open csr_get_txn_record ;