[Home] [Help]
227:
228: hr_utility.set_location(gv_package || lv_procedure_name, 20);
229:
230: lv_sql_string := 'select distinct pai.assignment_id
231: from pay_action_information pai
232: where pai.action_information_category =
233: decode(''' ||lv_affl_type|| ''',''HIRES'',''MX SS HIRE DETAILS'',''SEPARATIONS'',''MX SS SEPARATION DETAILS'')
234: and pai.action_information22 =''A''
235: and :payroll_action_id > 0 ' ;
265: ,cp_affl_type in varchar2
266: ) is
267:
268: select pai.action_context_id,pai.assignment_id,pai.tax_unit_id
269: from pay_action_information pai
270: where pai.assignment_id between cp_start_assignment_id and cp_end_assignment_id
271: and pai.action_information_category =
272: decode(cp_affl_type,'HIRES','MX SS HIRE DETAILS','SEPARATIONS','MX SS SEPARATION DETAILS')
273: and pai.action_information22 ='A'
459:
460: /************************************************************
461: Name : format_dispmag_emp_record
462: Purpose : This function retrieves the archived record from
463: pay action information table and format the record
464: in the dispmag employee record format.
465: This function is called from the DISPMAG_EMPLOYEE
466: fast formula by passing the parameters
467: Arguments : p_assignment_action_id - assignment_action_id context
488: IS
489:
490: /************************************************************
491: ** Cursor to get the hire/rehire affiliation records from
492: ** pay_action_information table
493: ************************************************************/
494:
495: cursor c_hire_details( cp_assignment_action_id in number
496: ) is
547: format_data_string(rpad(action_information18,10,' ')) ||
548: format_data_string(' ') ||
549: format_data_string(rpad(action_information20,18,' '))||
550: format_data_string(action_information21)
551: from pay_action_information pai,
552: pay_action_interlocks pal,
553: pay_assignment_actions paa
554: where pal.locking_action_id = cp_assignment_action_id
555: and pal.locked_action_id = pai.action_context_id
561:
562:
563: /************************************************************
564: ** Cursor to get the SEPARATION affiliation records from
565: ** pay_action_information table
566: ************************************************************/
567: cursor c_sep_details( cp_assignment_action_id in number
568: ) is
569:
607: format_data_string(rpad(action_information13,10,' ')) ||
608: format_data_string(nvl(action_information14,' ')) ||
609: format_data_string(rpad(' ',18,' ')) ||
610: format_data_string(action_information16)
611: from pay_action_information pai,
612: pay_action_interlocks pal,
613: pay_assignment_actions paa
614: where pal.locking_action_id = cp_assignment_action_id
615: and pal.locked_action_id = pai.action_context_id
620: and pai.tax_unit_id = paa.tax_unit_id ;
621:
622: /************************************************************
623: ** Cursor to get the salary affiliation records from
624: ** pay_action_information table
625: ************************************************************/
626:
627: cursor c_salary_details( cp_assignment_action_id in number
628: ) is
677: format_data_string(rpad(action_information18,10,' ')) ||
678: format_data_string(' ') ||
679: format_data_string(rpad(action_information20,18,' '))||
680: format_data_string(action_information21)
681: from pay_action_information pai
682: where pai.action_context_id = cp_assignment_action_id
683: and pai.action_information_category = 'MX SS SALARY DETAILS'
684: and pai.action_context_type ='AAP'
685: and pai.action_information22 ='A' ;