APPS.PQH_CBR_ENGINE dependencies on PQH_ATTRIBUTES

Line 432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;

428: l_sel_stmt varchar2(4000);
429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
434: l_selected_value_v varchar2(2000);
435: l_selected_value_n number;
436: l_selected_value_d date;

Line 433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;

429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
434: l_selected_value_v varchar2(2000);
435: l_selected_value_n number;
436: l_selected_value_d date;
437: l_proc varchar2(100) := 'get_transaction_value';

Line 446: from pqh_attributes

442:
443: -- get the attribute details
444: select column_name, master_table_route_id,column_type
445: into l_column_name, l_table_route_id,l_column_type
446: from pqh_attributes
447: where attribute_id = p_attribute_id;
448: hr_utility.set_location('column_name1 is : '||substr(l_column_name,1,50),10);
449: hr_utility.set_location('column_name2 is : '||substr(l_column_name,51,50),11);
450: hr_utility.set_location('column_name3 is : '||substr(l_column_name,101,50),12);

Line 1310: -- pqh_rule_attributes stores the attribute code (which links to attribute_id of pqh_attributes)

1306: l_valid_applicability boolean;
1307: l_valid_entity boolean;
1308: begin
1309: hr_utility.set_location('inside'||l_proc,10);
1310: -- pqh_rule_attributes stores the attribute code (which links to attribute_id of pqh_attributes)
1311: -- this attribute id is linked to txn_category budget reallocation
1312: -- In this procedure we are getting conditions defined for a rule and populating
1313: -- the seeded attributes by comparing attribute_id
1314: for l_condition_rec in csr_condition_rec loop

Line 1552: from pqh_attributes att,pqh_txn_category_attributes tcat, pqh_transaction_categories txn

1548: select tcat.txn_category_attribute_id tcat_attribute_id,
1549: att.attribute_id attribute_id,
1550: att.column_type column_type,
1551: att.column_name column_name
1552: from pqh_attributes att,pqh_txn_category_attributes tcat, pqh_transaction_categories txn
1553: where txn.transaction_category_id = tcat.transaction_category_id
1554: and txn.short_name = 'PQH_BPR'
1555: and txn.business_group_id is null
1556: and tcat.attribute_id = att.attribute_id