APPS.PQH_WORKFLOW dependencies on PQH_ATTRIBUTES

Line 2329: from pqh_attributes_vl

2325: where wdt.worksheet_detail_id = p_transaction_id
2326: and wdt.worksheet_id = wks.worksheet_id
2327: and wks.wf_transaction_category_id = p_tran_cat_id;
2328: cursor c1 is select attribute_name,column_name
2329: from pqh_attributes_vl
2330: where attribute_id = p_attribute_id
2331: and nvl(enable_flag,'X') ='Y';
2332: cursor c2 is select sty.shared_type_name unit_name,lkp.description avail_desc
2333: from pqh_budgets bgt, per_shared_types sty, hr_lookups lkp

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';