eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_SIT_ENGINE dependencies on PQH_TABLE_ROUTE

Line 30: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;

26: Function GET_TRANSACTION_VALUE (p_person_id IN number,
27: p_effective_date in date,
28: p_attribute_id IN number) RETURN varchar2 IS
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;

Line 31: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;

27: p_effective_date in date,
28: p_attribute_id IN number) RETURN varchar2 IS
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);

Line 32: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;

28: p_attribute_id IN number) RETURN varchar2 IS
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;

Line 39: l_table_route_id PQH_TABLE_ROUTE.TABLE_ROUTE_ID%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';
39: l_table_route_id PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE;
40: BEGIN
41: hr_utility.set_location('Entering : '||l_proc, 5);
42: if (p_person_id is not null and p_attribute_id is not null) then
43:

Line 60: from pqh_table_route where table_route_id = l_table_route_id;

56: -- table route is selected, get the details
57:
58: select from_clause, where_clause
59: into l_from_clause, l_where_clause_in
60: from pqh_table_route where table_route_id = l_table_route_id;
61:
62: hr_utility.set_location('from_clause1 is : '||substr(l_from_clause,1,30),30);
63: hr_utility.set_location('from_clause2 is : '||substr(l_from_clause,31,30),31);
64: hr_utility.set_location('where_clause 1is : '||substr(l_where_clause_in,1,40),40);