APPS.PQH_WORKFLOW dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 2551: from pqh_attributes att, pqh_txn_category_attributes tca

2547: and nvl(rc.delete_flag,'N') = 'N'
2548: and nvl(rc.default_flag,'X') <> 'Y' );
2549: cursor c2 is
2550: select att.attribute_id,att.attribute_name,att.column_name,att.column_type
2551: from pqh_attributes att, pqh_txn_category_attributes tca
2552: where att.attribute_id = tca.attribute_id
2553: and tca.transaction_category_id = p_tran_cat_id
2554: and tca.list_identifying_flag = 'Y'
2555: and nvl(att.enable_flag,'X') = 'Y';

Line 2898: from pqh_attributes att, pqh_txn_category_attributes tca

2894: and nvl(enable_flag,'X') = 'Y'
2895: and nvl(delete_flag,'N') = 'N';
2896: cursor c2 is
2897: select att.attribute_id,att.attribute_name,att.column_name,att.column_type
2898: from pqh_attributes att, pqh_txn_category_attributes tca
2899: where att.attribute_id = tca.attribute_id and
2900: tca.transaction_category_id = p_tran_cat_id
2901: and tca.member_identifying_flag = 'Y'
2902: and nvl(att.enable_flag,'X') = 'Y';

Line 3171: from pqh_attributes att,pqh_txn_category_attributes tca

3167: and nvl(delete_flag,'N') = 'N'
3168: and nvl(enable_flag,'X') ='Y';
3169: cursor c2 is
3170: select att.attribute_id,att.attribute_name,att.column_name,att.column_type
3171: from pqh_attributes att,pqh_txn_category_attributes tca
3172: where att.attribute_id = tca.attribute_id and
3173: tca.transaction_category_id = p_tran_cat_id
3174: and tca.member_identifying_flag = 'Y'
3175: and nvl(att.enable_flag,'X') = 'Y';

Line 3409: from pqh_attributes att, pqh_txn_category_attributes tca

3405: and nvl(delete_flag,'N') = 'N'
3406: and nvl(enable_flag,'X') ='Y';
3407: cursor c2 is
3408: select att.attribute_id,att.attribute_name,att.column_name,att.column_type
3409: from pqh_attributes att, pqh_txn_category_attributes tca
3410: where att.attribute_id = tca.attribute_id and
3411: tca.transaction_category_id = p_tran_cat_id
3412: and tca.member_identifying_flag = 'Y'
3413: and nvl(att.enable_flag,'X') = 'Y';