[Home] [Help]
719: hsck.SEGMENT3 association_code,
720: hsck.segment14 agreement_code,
721: paaf.payroll_id
722: FROM per_all_assignments_f paaf,
723: per_all_people_f papf,
724: hr_soft_coding_keyflex hsck
725: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
726: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
727: AND papf.person_id=paaf.person_id
759: l_assignment_start_date DATE;
760: l_assignment_end_date DATE;
761: l_absence_count NUMBER;
762: l_employee_category per_all_assignments_f.employee_category%type;
763: l_person_number per_all_people_f.national_identifier%TYPE;
764: l_person_name VARCHAR2(350);
765:
766: l_terminated VARCHAR2(50);
767:
773: l_value number;
774: L_CFAR_NUMBER NUMBER;
775: l_legal_employer_id hr_organization_units.organization_id%TYPE;
776: l_virtual_date DATE;
777: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;
778: l_counter NUMBER :=0;
779: l_total_salary NUMBER;
780: l_asg_start_date DATE;
781: l_asg_end_date date;
804: l_legal_employer hr_organization_units.name%TYPE;
805: l_organization_id varchar2(20);
806: l_membership_number varchar2(10);
807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
808: l_person_id per_all_people_f.person_id%TYPE;
809: l_ssyk hr_lookups.lookup_code%TYPE;
810: l_ssyk_code hr_lookups.meaning%TYPE;
811: l_association_code varchar2(10);
812: l_payroll_id pay_payrolls_f.payroll_id%TYPE;