APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PER_ALL_PEOPLE_F

Line 722: per_all_people_f papf,

718: hsck.SEGMENT3 association_code,
719: hsck.segment14 agreement_code,
720: paaf.payroll_id
721: FROM per_all_assignments_f paaf,
722: per_all_people_f papf,
723: hr_soft_coding_keyflex hsck
724: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
725: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
726: AND papf.person_id=paaf.person_id

Line 761: l_person_number per_all_people_f.national_identifier%TYPE;

757: l_assignment_start_date DATE;
758: l_assignment_end_date DATE;
759: l_absence_count NUMBER;
760: l_employee_category per_all_assignments_f.employee_category%type;
761: l_person_number per_all_people_f.national_identifier%TYPE;
762: l_person_name VARCHAR2(350);
763:
764: l_terminated VARCHAR2(50);
765:

Line 775: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;

771: l_value number;
772: L_CFAR_NUMBER NUMBER;
773: l_legal_employer_id hr_organization_units.organization_id%TYPE;
774: l_virtual_date DATE;
775: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;
776: l_counter NUMBER :=0;
777: l_total_salary NUMBER;
778: l_asg_start_date DATE;
779: l_asg_end_date date;

Line 806: l_person_id per_all_people_f.person_id%TYPE;

802: l_legal_employer hr_organization_units.name%TYPE;
803: l_organization_id varchar2(20);
804: l_membership_number varchar2(10);
805: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
806: l_person_id per_all_people_f.person_id%TYPE;
807: l_ssyk hr_lookups.lookup_code%TYPE;
808: l_ssyk_code hr_lookups.meaning%TYPE;
809: l_association_code varchar2(10);
810: l_payroll_id pay_payrolls_f.payroll_id%TYPE;