DBA Data[Home] [Help]

APPS.PQH_PROCESS_TENURE_STATUS dependencies on HR_API_TRANSACTION_VALUES

Line 78: hr_api_transaction_values a

74: decode(a.name, 'P_PERSON_EXTRA_INFO_ID' , a.varchar2_value ,null) person_extra_info_id,
75: decode(a.name, 'P_OBJECT_VERSION_NUMBER', a.varchar2_value ,null) object_version_number,
76: decode(a.name, 'P_SUBJECT_TO_QUOTA' , a.varchar2_value ,null) pei_information6
77: FROM hr_api_transaction_steps s,
78: hr_api_transaction_values a
79: WHERE s.transaction_step_id = a.transaction_step_id
80: and s.transaction_step_id = p_transaction_step_id
81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'
82: )