APPS.PQH_PROCESS_EMP_REVIEW dependencies on HR_API_TRANSACTION_VALUES

Line 36: from hr_api_transaction_values abc

32: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_COMMENTS'||x_row) comments,
33: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_STATUS'||x_row) status,
34: hr_transaction_api.get_varchar2_value (p_transaction_step_id , 'P_BUSINESS_GROUP_ID'||x_row) business_group_id
35: FROM ( select substr(abc.name,14) x_row
36: from hr_api_transaction_values abc
37: where abc.transaction_step_id = p_transaction_step_id
38: and abc.name like 'P_EMPLOYEE_NO%'
39: ) x
40: ) reviewer,

Line 98: hr_api_transaction_values a

94: decode(a.name, 'P_ASSIGNMENT_ID' , a.varchar2_value ,null) Assignment_Id,
95: decode(a.name, 'P_NOTIFY_FLAG' , a.varchar2_value ,null) Notify_Flag,
96: decode(a.name, 'P_BUSINESS_GROUP_ID' , a.varchar2_value ,null) Business_Group_Id
97: FROM hr_api_transaction_steps s,
98: hr_api_transaction_values a
99: WHERE s.transaction_step_id = a.transaction_step_id
100: AND s.transaction_step_id = p_transaction_step_id
101: AND s.api_name = 'PQH_PROCESS_EMP_REVIEW.PROCESS_API'
102: )

Line 266: from hr_api_transaction_values

262: x_total_deleted_rows OUT NOCOPY NUMBER) is
263:
264: cursor Rec_Count(p_step_id varchar2) is
265: select count(*)
266: from hr_api_transaction_values
267: where transaction_step_id = p_step_id
268: and name like 'P_EMPLOYEE_NO_';
269:
270: cursor Rec_Count_Deleted(p_step_id varchar2) is

Line 272: from hr_api_transaction_values

268: and name like 'P_EMPLOYEE_NO_';
269:
270: cursor Rec_Count_Deleted(p_step_id varchar2) is
271: select count(*)
272: from hr_api_transaction_values
273: where transaction_step_id = p_step_id
274: and name like 'P_EMPLOYEE_NO%D';
275:
276: