eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 721: FROM per_all_assignments_f paaf,

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

Line 760: l_employee_category per_all_assignments_f.employee_category%type;

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

Line 780: l_category per_all_assignments_f.employee_category%type;

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

Line 781: l_prev_category per_all_assignments_f.employee_category%type;

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

Line 783: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;

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

Line 784: l_frequency per_all_assignments_f.frequency%type;

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

Line 785: l_normal_hours per_all_assignments_f.normal_hours%type;

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

Line 805: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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