Salary HSDL template to list only the actions related to salary update in LOV.
Salary upload HSDL template to list only the actions related to salary update in LOV as in the application. Currently the VO used "oracle.apps.hcm.compensation.salary.core.publicView.SalaryActionsPVO" has below query and hence it lists all the actions.
—SELECT * FROM (select pac.business_group_id ,pac.action_id ,pac.action_code ,pac.action_name ,pac.start_date ,pac.end_date ,pac.action_type_code ,pac.action_type_id ,pac.country ,pac.is_system_action from per_actions_vl pac where :pStartDate between pac.start_date and pac.end_date and decode(pac.country, null, 'Y', decode(sign(instr(pac.country,nvl(:countryCode,pac.country)) ),1,'Y','N')) = 'Y') QRSLT ORDER BY "ACTION_NAME"—