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_SA_GOSI_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 602: from hr_organization_units

598: close get_employer_GOSI;
599: begin
600: select name
601: into l_employer_gosi_office_name
602: from hr_organization_units
603: where organization_id = l_employer_gosi_office;
604: exception
605: when others then
606: l_employer_gosi_office_name := null;

Line 2725: ,hr_organization_units hou

2721: select hla.town_or_city
2722: ,hla.region_2
2723: ,hla.region_3
2724: from hr_locations_all hla
2725: ,hr_organization_units hou
2726: ,per_all_assignments_f paa
2727: where paa.organization_id = hou.organization_id
2728: and hou.location_id = hla.location_id
2729: and paa.assignment_id = l_assignment_id

Line 2911: l_gre_name HR_ORGANIZATION_UNITS.NAME%TYPE;

2907: TYPE t_tab_emp is TABLE of t_rec_emp
2908: INDEX BY BINARY_INTEGER;
2909: t_emp t_tab_emp;
2910: i NUMBER(15);
2911: l_gre_name HR_ORGANIZATION_UNITS.NAME%TYPE;
2912: l_gre_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
2913: l_gre_present NUMBER;
2914: l_person_id_new number;
2915: l_lower_base VARCHAR2(10) := NULL;

Line 2912: l_gre_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;

2908: INDEX BY BINARY_INTEGER;
2909: t_emp t_tab_emp;
2910: i NUMBER(15);
2911: l_gre_name HR_ORGANIZATION_UNITS.NAME%TYPE;
2912: l_gre_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
2913: l_gre_present NUMBER;
2914: l_person_id_new number;
2915: l_lower_base VARCHAR2(10) := NULL;
2916: l_upper_base VARCHAR2(10) := NULL;

Line 3067: from hr_organization_units

3063: close get_employer;
3064: begin
3065: select name
3066: into l_employer_name
3067: from hr_organization_units
3068: where organization_id = l_org_id;
3069: exception
3070: when others then
3071: l_employer_name := null;

Line 3079: from hr_organization_units

3075: close get_employer_GOSI;
3076: begin
3077: select name
3078: into l_employer_gosi_office_name
3079: from hr_organization_units
3080: where organization_id = l_employer_gosi_office;
3081: exception
3082: when others then
3083: l_employer_gosi_office_name := null;