APPS.PAY_SE_SALARY_STRUCTURE_STATS dependencies on PER_ALL_ASSIGNMENTS_F

Line 660: CURSOR csr_extra_assignment(csr_v_assignment_id per_all_assignments_f.assignment_id%type)

656: AND o1.organization_id =hoi2.organization_id
657: AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS';
658:
659: /* Assignment level Extra information EIT Details */
660: CURSOR csr_extra_assignment(csr_v_assignment_id per_all_assignments_f.assignment_id%type)
661: IS
662: SELECT hl.meaning
663: FROM per_assignment_extra_info,
664: hr_lookups hl

Line 722: FROM per_all_assignments_f paaf,

718: hsck.SEGMENT3 ssyk_code,
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

Line 762: l_employee_category per_all_assignments_f.employee_category%type;

758: l_assignment_category VARCHAR2(5);
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);

Line 782: l_category per_all_assignments_f.employee_category%type;

778: l_counter NUMBER :=0;
779: l_total_salary NUMBER;
780: l_asg_start_date DATE;
781: l_asg_end_date date;
782: l_category per_all_assignments_f.employee_category%type;
783: l_prev_category per_all_assignments_f.employee_category%type;
784: l_working_percentage NUMBER;
785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
786: l_frequency per_all_assignments_f.frequency%type;

Line 783: l_prev_category per_all_assignments_f.employee_category%type;

779: l_total_salary NUMBER;
780: l_asg_start_date DATE;
781: l_asg_end_date date;
782: l_category per_all_assignments_f.employee_category%type;
783: l_prev_category per_all_assignments_f.employee_category%type;
784: l_working_percentage NUMBER;
785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
786: l_frequency per_all_assignments_f.frequency%type;
787: l_normal_hours per_all_assignments_f.normal_hours%type;

Line 785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;

781: l_asg_end_date date;
782: l_category per_all_assignments_f.employee_category%type;
783: l_prev_category per_all_assignments_f.employee_category%type;
784: l_working_percentage NUMBER;
785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
786: l_frequency per_all_assignments_f.frequency%type;
787: l_normal_hours per_all_assignments_f.normal_hours%type;
788: l_include_event char(1);
789: l_wrk_schd_return NUMBER;

Line 786: l_frequency per_all_assignments_f.frequency%type;

782: l_category per_all_assignments_f.employee_category%type;
783: l_prev_category per_all_assignments_f.employee_category%type;
784: l_working_percentage NUMBER;
785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
786: l_frequency per_all_assignments_f.frequency%type;
787: l_normal_hours per_all_assignments_f.normal_hours%type;
788: l_include_event char(1);
789: l_wrk_schd_return NUMBER;
790: l_wrk_duration NUMBER;

Line 787: l_normal_hours per_all_assignments_f.normal_hours%type;

783: l_prev_category per_all_assignments_f.employee_category%type;
784: l_working_percentage NUMBER;
785: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
786: l_frequency per_all_assignments_f.frequency%type;
787: l_normal_hours per_all_assignments_f.normal_hours%type;
788: l_include_event char(1);
789: l_wrk_schd_return NUMBER;
790: l_wrk_duration NUMBER;
791: l_absence_start_date DATE;

Line 807: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

803: l_weekend_duty varchar2(10);
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);