APPS.PQH_SAT_SHD dependencies on PQH_ATTRIBUTES

Line 260: l_attribute_id pqh_attributes.attribute_id%TYPE ;

256: l_effective_date date := sysdate ;
257: l_object_version_number number := 1;
258: l_language varchar2(30) ;
259: --
260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;

Line 261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;

257: l_object_version_number number := 1;
258: l_language varchar2(30) ;
259: --
260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --

Line 279: from pqh_attributes

275: -- developer key is TXN_CATEGORY_ATTRIBUTE_ID + ATTRIBUTE_TYPE_CD + CONTEXT
276: --
277: cursor csr_attribute_id(p_column_name IN VARCHAR2, p_table_id IN NUMBER) is
278: select attribute_id
279: from pqh_attributes
280: where key_column_name = p_column_name
281: and legislation_code is null
282: and nvl(master_table_route_id,-999) = nvl(p_table_id, -999);
283: --