APPS.PQH_SIT_ENGINE dependencies on PQH_ATTRIBUTES

Line 33: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;

29: l_sel_stmt varchar2(4000);
30: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
31: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
32: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
33: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
34: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
35: l_selected_value_v varchar2(2000);
36: l_selected_value_n number;
37: l_selected_value_d date;

Line 34: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;

30: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
31: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
32: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
33: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
34: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
35: l_selected_value_v varchar2(2000);
36: l_selected_value_n number;
37: l_selected_value_d date;
38: l_proc varchar2(100) := 'get_transaction_value';

Line 47: from pqh_attributes

43:
44: -- get the attribute details
45: select column_name, master_table_route_id,column_type
46: into l_column_name, l_table_route_id,l_column_type
47: from pqh_attributes
48: where attribute_id = p_attribute_id;
49: hr_utility.set_location('column_name1 is : '||substr(l_column_name,1,50),10);
50: hr_utility.set_location('column_name2 is : '||substr(l_column_name,51,50),11);
51: hr_utility.set_location('column_name3 is : '||substr(l_column_name,101,50),12);