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

Line 122: l_emp_id hr_organization_units.organization_id%TYPE ;

118: l_local_unit_id NUMBER ;
119: d_local_unit_id NUMBER ;
120: l_local VARCHAR2(10);
121: l_emp_type VARCHAR2(2);
122: l_emp_id hr_organization_units.organization_id%TYPE ;
123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;

Line 123: l_emp_name hr_organization_units.name%TYPE;

119: d_local_unit_id NUMBER ;
120: l_local VARCHAR2(10);
121: l_emp_type VARCHAR2(2);
122: l_emp_id hr_organization_units.organization_id%TYPE ;
123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;

Line 124: l_le_name hr_organization_units.name%TYPE ;

120: l_local VARCHAR2(10);
121: l_emp_type VARCHAR2(2);
122: l_emp_id hr_organization_units.organization_id%TYPE ;
123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;

Line 125: l_lu_name hr_organization_units.name%TYPE ;

121: l_emp_type VARCHAR2(2);
122: l_emp_id hr_organization_units.organization_id%TYPE ;
123: l_emp_name hr_organization_units.name%TYPE;
124: l_le_name hr_organization_units.name%TYPE ;
125: l_lu_name hr_organization_units.name%TYPE ;
126: l_element_name pay_element_types_f.element_name%TYPE;
127: l_element_set_name pay_element_sets.element_set_name%TYPE;
128: l_business_id hr_organization_information.org_information1%TYPE ;
129: l_y_number hr_organization_information.org_information1%TYPE ;

Line 147: FROM hr_organization_units o1

143: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id
144: hr_organization_information.ORGANIZATION_ID%TYPE)
145: IS
146: SELECT o1.name , hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION7
147: FROM hr_organization_units o1
148: , hr_organization_information hoi1
149: , hr_organization_information hoi2
150: WHERE o1.business_group_id =l_business_group_id
151: AND hoi1.organization_id = o1.organization_id

Line 162: FROM hr_organization_units o1

158: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id
159: hr_organization_information.ORGANIZATION_ID%TYPE)
160: IS
161: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION11
162: FROM hr_organization_units o1
163: , hr_organization_information hoi1
164: , hr_organization_information hoi2
165: WHERE o1.business_group_id =l_business_group_id
166: AND hoi1.organization_id = o1.organization_id

Line 199: hr_organization_units.organization_id%TYPE)

195: FROM pay_element_set_members
196: WHERE element_set_id=csr_v_element_set_id;
197: rg_ElementSet_Members csr_ElementSet_Members%rowtype;
198: Cursor csr_Local_unit_Legal(csr_v_legal_unit_id
199: hr_organization_units.organization_id%TYPE)
200: IS
201: SELECT hoi2.ORG_INFORMATION1 local_unit
202: FROM hr_organization_units o1
203: , hr_organization_information hoi1

Line 202: FROM hr_organization_units o1

198: Cursor csr_Local_unit_Legal(csr_v_legal_unit_id
199: hr_organization_units.organization_id%TYPE)
200: IS
201: SELECT hoi2.ORG_INFORMATION1 local_unit
202: FROM hr_organization_units o1
203: , hr_organization_information hoi1
204: , hr_organization_information hoi2
205: WHERE o1.business_group_id =l_business_group_id
206: AND hoi1.organization_id = o1.organization_id