748: --------------------------------------------------------------------+
749:
750: procedure assignment_action_code
751: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
752: ,p_start_person in per_all_people_f.person_id%type
753: ,p_end_person in per_all_people_f.person_id%type
754: ,p_chunk in number
755: ) is
756: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
749:
750: procedure assignment_action_code
751: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
752: ,p_start_person in per_all_people_f.person_id%type
753: ,p_end_person in per_all_people_f.person_id%type
754: ,p_chunk in number
755: ) is
756: cursor get_ps_params(c_payroll_action_id per_all_assignments_f.assignment_id%type)
757: is
777: --
778: --------------------------------------------------------------------+
779: cursor csr_assignment_paysum
780: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
781: ,c_start_person per_all_people_f.person_id%type
782: ,c_end_person per_all_people_f.person_id%type
783: ,c_employee_type per_all_people_f.current_employee_flag%type
784: ,c_business_group_id hr_all_organization_units.organization_id%type
785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
778: --------------------------------------------------------------------+
779: cursor csr_assignment_paysum
780: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
781: ,c_start_person per_all_people_f.person_id%type
782: ,c_end_person per_all_people_f.person_id%type
783: ,c_employee_type per_all_people_f.current_employee_flag%type
784: ,c_business_group_id hr_all_organization_units.organization_id%type
785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
786: ,c_payroll_id varchar2
779: cursor csr_assignment_paysum
780: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
781: ,c_start_person per_all_people_f.person_id%type
782: ,c_end_person per_all_people_f.person_id%type
783: ,c_employee_type per_all_people_f.current_employee_flag%type
784: ,c_business_group_id hr_all_organization_units.organization_id%type
785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
786: ,c_payroll_id varchar2
787: ,c_fin_year_start date
860: --------------------------------------------------------------------+
861:
862: cursor csr_assignment_only_paysum
863: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
864: ,c_start_person per_all_people_f.person_id%type
865: ,c_end_person per_all_people_f.person_id%type
866: ,c_employee_type per_all_people_f.current_employee_flag%type
867: ,c_business_group_id hr_all_organization_units.organization_id%type
868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
861:
862: cursor csr_assignment_only_paysum
863: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
864: ,c_start_person per_all_people_f.person_id%type
865: ,c_end_person per_all_people_f.person_id%type
866: ,c_employee_type per_all_people_f.current_employee_flag%type
867: ,c_business_group_id hr_all_organization_units.organization_id%type
868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
869: ,c_payroll_id varchar2
862: cursor csr_assignment_only_paysum
863: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
864: ,c_start_person per_all_people_f.person_id%type
865: ,c_end_person per_all_people_f.person_id%type
866: ,c_employee_type per_all_people_f.current_employee_flag%type
867: ,c_business_group_id hr_all_organization_units.organization_id%type
868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
869: ,c_payroll_id varchar2
870: ,c_fin_year_start date
948:
949: CURSOR csr_range_assignment_paysum
950: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
951: ,c_chunk NUMBER
952: ,c_employee_type per_all_people_f.current_employee_flag%type
953: ,c_business_group_id hr_all_organization_units.organization_id%type
954: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
955: ,c_payroll_id varchar2
956: ,c_fin_year_start date