717: p_date_to in date,
718: p_action_type in varchar2,
719: p_server_validate in varchar2 default 'Y' ) is
720: begin
721: set_query_bindvar( 'BUSINESS_GROUP_ID',fnd_profile.value('PER_BUSINESS_GROUP_ID'));
722: set_query_bindvar( 'PAYROLL_ID', to_number(p_payroll_id));
723: set_query_bindvar( 'PERIOD_DATE_FROM', nvl(to_char(p_date_from,'YYYY/MM/DD'),
724: to_char(hr_general.start_of_time,'YYYY/MM/DD')));
725: set_query_bindvar( 'PERIOD_DATE_TO', nvl(to_char(p_date_to,'YYYY/MM/DD'),