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

Line 20: g_pension_provider hr_organization_units.organization_id%TYPE ;

16: g_emp_type VARCHAR2(2);
17: g_legal_employer_id NUMBER;
18: g_local_unit_id NUMBER ;
19: g_effective_date DATE;
20: g_pension_provider hr_organization_units.organization_id%TYPE ;
21: g_pension_ins_num hr_organization_information.org_information1%TYPE ;
22: g_payroll_action_id NUMBER ;
23: g_le_assignment_action_id NUMBER ;
24: g_lu_assignment_action_id NUMBER ;

Line 154: l_emp_id hr_organization_units.organization_id%TYPE ;

150: l_year VARCHAR2(4);
151: l_canonical_start_date DATE;
152: l_canonical_end_date DATE;
153: l_emp_type VARCHAR2(2);
154: l_emp_id hr_organization_units.organization_id%TYPE ;
155: l_customer_num hr_organization_information.org_information1%TYPE ;
156: l_pension_ins_num hr_organization_information.org_information1%TYPE ;
157: l_dept_code VARCHAR2(3);
158:

Line 160: l_pp_name hr_organization_units.name%TYPE ;

156: l_pension_ins_num hr_organization_information.org_information1%TYPE ;
157: l_dept_code VARCHAR2(3);
158:
159: l_Record_code VARCHAR2(240) :=' ';
160: l_pp_name hr_organization_units.name%TYPE ;
161: l_emp_name hr_organization_units.name%TYPE ;
162: l_le_name hr_organization_units.name%TYPE ;
163: l_lu_name hr_organization_units.name%TYPE ;
164: l_business_id hr_organization_information.org_information1%TYPE ;

Line 161: l_emp_name hr_organization_units.name%TYPE ;

157: l_dept_code VARCHAR2(3);
158:
159: l_Record_code VARCHAR2(240) :=' ';
160: l_pp_name hr_organization_units.name%TYPE ;
161: l_emp_name hr_organization_units.name%TYPE ;
162: l_le_name hr_organization_units.name%TYPE ;
163: l_lu_name hr_organization_units.name%TYPE ;
164: l_business_id hr_organization_information.org_information1%TYPE ;
165: l_y_number hr_organization_information.org_information1%TYPE ;

Line 162: l_le_name hr_organization_units.name%TYPE ;

158:
159: l_Record_code VARCHAR2(240) :=' ';
160: l_pp_name hr_organization_units.name%TYPE ;
161: l_emp_name hr_organization_units.name%TYPE ;
162: l_le_name hr_organization_units.name%TYPE ;
163: l_lu_name hr_organization_units.name%TYPE ;
164: l_business_id hr_organization_information.org_information1%TYPE ;
165: l_y_number hr_organization_information.org_information1%TYPE ;
166: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 163: l_lu_name hr_organization_units.name%TYPE ;

159: l_Record_code VARCHAR2(240) :=' ';
160: l_pp_name hr_organization_units.name%TYPE ;
161: l_emp_name hr_organization_units.name%TYPE ;
162: l_le_name hr_organization_units.name%TYPE ;
163: l_lu_name hr_organization_units.name%TYPE ;
164: l_business_id hr_organization_information.org_information1%TYPE ;
165: l_y_number hr_organization_information.org_information1%TYPE ;
166: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
167: l_counter number := 0;

Line 177: FROM hr_organization_units o1

173: CURSOR csr_pension_provider_details ( csr_v_pension_provider_id hr_organization_information.organization_id%TYPE
174: )
175: IS
176: SELECT o1.NAME
177: FROM hr_organization_units o1
178: , hr_organization_information hoi1
179: WHERE o1.business_group_id =l_business_group_id
180: AND hoi1.organization_id = o1.organization_id
181: AND hoi1.organization_id = csr_v_pension_provider_id

Line 192: FROM hr_organization_units o1

188:
189: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
190: IS
191: SELECT o1.name , hoi2.ORG_INFORMATION1
192: FROM hr_organization_units o1
193: , hr_organization_information hoi1
194: , hr_organization_information hoi2
195: WHERE o1.business_group_id =l_business_group_id
196: AND hoi1.organization_id = o1.organization_id

Line 211: FROM hr_organization_units o1

207: , csr_v_pension_ins_num hr_organization_information.ORG_INFORMATION1%TYPE
208: , csr_v_effective_date DATE )
209: IS
210: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi3.ORG_INFORMATION4 , hoi3.ORG_INFORMATION6, hoi3.ORG_INFORMATION8
211: FROM hr_organization_units o1
212: , hr_organization_information hoi1
213: , hr_organization_information hoi2
214: , hr_organization_information hoi3
215: WHERE o1.business_group_id =l_business_group_id

Line 234: FROM hr_organization_units o1

230: Cursor csr_lu_pp_dtls ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE
231: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE)
232: IS
233: SELECT hoi2.ORG_INFORMATION2
234: FROM hr_organization_units o1
235: , hr_organization_information hoi1
236: , hr_organization_information hoi2
237: WHERE o1.business_group_id =l_business_group_id
238: AND hoi1.organization_id = o1.organization_id

Line 255: FROM hr_organization_units o1

251: , csr_v_pension_provider hr_organization_information.org_information1%TYPE
252: ,csr_v_effective_date DATE )
253: IS
254: SELECT hoi2.ORG_INFORMATION6 , hoi2.ORG_INFORMATION8
255: FROM hr_organization_units o1
256: , hr_organization_information hoi1
257: , hr_organization_information hoi2
258: WHERE o1.business_group_id =l_business_group_id
259: AND hoi1.organization_id = o1.organization_id

Line 281: FROM hr_organization_units o1

277: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE
278: )
279: IS
280: SELECT hoi2.ORG_INFORMATION3
281: FROM hr_organization_units o1
282: , hr_organization_information hoi1
283: , hr_organization_information hoi2
284: WHERE o1.business_group_id =l_business_group_id
285: AND hoi1.organization_id = o1.organization_id