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_INFORMATION

Line 21: g_pension_ins_num hr_organization_information.org_information1%TYPE ;

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 ;
25:

Line 155: l_customer_num hr_organization_information.org_information1%TYPE ;

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:
159: l_Record_code VARCHAR2(240) :=' ';

Line 156: l_pension_ins_num hr_organization_information.org_information1%TYPE ;

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:
159: l_Record_code VARCHAR2(240) :=' ';
160: l_pp_name hr_organization_units.name%TYPE ;

Line 164: l_business_id hr_organization_information.org_information1%TYPE ;

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;
168:

Line 165: l_y_number hr_organization_information.org_information1%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;
168:
169:

Line 173: CURSOR csr_pension_provider_details ( csr_v_pension_provider_id hr_organization_information.organization_id%TYPE

169:
170: /* Cursors */
171:
172:
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

Line 178: , hr_organization_information hoi1

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
182: AND hoi1.org_information_context = 'CLASS'

Line 189: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

185: rg_pension_provider_details csr_pension_provider_details%ROWTYPE;
186:
187:
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

Line 193: , hr_organization_information hoi1

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
197: AND hoi1.organization_id = csr_v_local_unit_id

Line 194: , hr_organization_information hoi2

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
197: AND hoi1.organization_id = csr_v_local_unit_id
198: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 206: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE

202:
203: rg_Local_Unit_Details csr_Local_Unit_Details%rowtype;
204:
205: Cursor csr_Legal_Emp_Details
206: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
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

Line 207: , csr_v_pension_ins_num hr_organization_information.ORG_INFORMATION1%TYPE

203: rg_Local_Unit_Details csr_Local_Unit_Details%rowtype;
204:
205: Cursor csr_Legal_Emp_Details
206: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
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

Line 212: , hr_organization_information hoi1

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
216: AND hoi1.organization_id = o1.organization_id

Line 213: , hr_organization_information hoi2

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
216: AND hoi1.organization_id = o1.organization_id
217: AND hoi1.organization_id = csr_v_legal_emp_id

Line 214: , hr_organization_information hoi3

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
216: AND hoi1.organization_id = o1.organization_id
217: AND hoi1.organization_id = csr_v_legal_emp_id
218: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 230: Cursor csr_lu_pp_dtls ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE

226: nvl(fnd_date.canonical_to_date(hoi3.org_information2),to_date('31/12/4712','DD/MM/YYYY')) ;
227:
228: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
229: /*
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

Line 231: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE)

227:
228: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
229: /*
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

Line 235: , hr_organization_information hoi1

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
239: AND hoi1.organization_id = csr_v_local_unit_id

Line 236: , hr_organization_information hoi2

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
239: AND hoi1.organization_id = csr_v_local_unit_id
240: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 249: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE

245:
246: rg_lu_pp_dtls csr_lu_pp_dtls%rowtype;
247:
248: Cursor csr_le_pp_dtls
249: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
250: , csr_v_pension_type hr_organization_information.org_information1%TYPE
251: , csr_v_pension_provider hr_organization_information.org_information1%TYPE
252: ,csr_v_effective_date DATE )
253: IS

Line 250: , csr_v_pension_type hr_organization_information.org_information1%TYPE

246: rg_lu_pp_dtls csr_lu_pp_dtls%rowtype;
247:
248: Cursor csr_le_pp_dtls
249: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
250: , csr_v_pension_type hr_organization_information.org_information1%TYPE
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

Line 251: , csr_v_pension_provider hr_organization_information.org_information1%TYPE

247:
248: Cursor csr_le_pp_dtls
249: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
250: , csr_v_pension_type hr_organization_information.org_information1%TYPE
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

Line 256: , hr_organization_information hoi1

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
260: AND hoi1.organization_id = csr_v_legal_emp_id

Line 257: , hr_organization_information hoi2

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
260: AND hoi1.organization_id = csr_v_legal_emp_id
261: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 275: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,

271: rg_le_pp_dtls csr_le_pp_dtls%rowtype;
272: */
273:
274: CURSOR csr_Department_code (
275: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,
276: csr_v_legal_emp_id hr_organization_information.organization_id%TYPE,
277: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE
278: )
279: IS

Line 276: csr_v_legal_emp_id hr_organization_information.organization_id%TYPE,

272: */
273:
274: CURSOR csr_Department_code (
275: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,
276: csr_v_legal_emp_id hr_organization_information.organization_id%TYPE,
277: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE
278: )
279: IS
280: SELECT hoi2.ORG_INFORMATION3

Line 277: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE

273:
274: CURSOR csr_Department_code (
275: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,
276: csr_v_legal_emp_id hr_organization_information.organization_id%TYPE,
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

Line 282: , hr_organization_information hoi1

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
286: AND hoi1.organization_id = csr_v_pension_provider_id

Line 283: , hr_organization_information hoi2

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
286: AND hoi1.organization_id = csr_v_pension_provider_id
287: AND hoi1.org_information_context = 'CLASS'

Line 709: l_pension_ins_num hr_organization_information.org_information1%TYPE ;

705: l_month VARCHAR2(2);
706: l_year VARCHAR2(4);
707: l_canonical_start_date DATE;
708: l_canonical_end_date DATE;
709: l_pension_ins_num hr_organization_information.org_information1%TYPE ;
710:
711:
712: l_prepay_action_id NUMBER;
713: l_actid NUMBER;

Line 1123: l_pension_type hr_organization_information.org_information1%TYPE ;

1119: l_ovn NUMBER;
1120: l_business_group_id NUMBER;
1121: l_month VARCHAR2(2);
1122: l_year VARCHAR2(4);
1123: l_pension_type hr_organization_information.org_information1%TYPE ;
1124: */
1125: BEGIN
1126: IF g_debug THEN
1127: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);