DBA Data[Home] [Help]

APPS.PQH_TCA_SHD dependencies on FND_FLEX_VALUE_SETS

Line 298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;

Line 339: from fnd_flex_value_sets

335: and transaction_category_id = p_txn_category_id;
336: --
337: cursor csr_value_set_id (p_value_set_name IN VARCHAR2) is
338: select flex_value_set_id
339: from fnd_flex_value_sets
340: where flex_value_set_name = p_value_set_name;
341: --
342: --
343: Cursor csr_local_txn_cat_id is