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_NO_ARCHIVE_RSEA dependencies on HR_ORGANIZATION_INFORMATION

Line 149: l_business_id hr_organization_information.org_information1%TYPE ;

145: l_legal_employer_id NUMBER ;
146: l_local_unit_id NUMBER ;
147: l_emp_id hr_organization_units.organization_id%TYPE ;
148: l_lu_name hr_organization_units.name%TYPE ;
149: l_business_id hr_organization_information.org_information1%TYPE ;
150: l_archive VARCHAR2(3);
151:
152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;

Line 153: l_org_number hr_organization_information.org_information1%TYPE ;

149: l_business_id hr_organization_information.org_information1%TYPE ;
150: l_archive VARCHAR2(3);
151:
152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;

Line 154: l_municipal_no hr_organization_information.org_information1%TYPE ;

150: l_archive VARCHAR2(3);
151:
152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:

Line 155: l_industry_status hr_organization_information.org_information1%TYPE ;

151:
152: l_le_name hr_organization_units.name%TYPE ;
153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;

Line 157: l_tax_office_id hr_organization_information.organization_id%TYPE ;

153: l_org_number hr_organization_information.org_information1%TYPE ;
154: l_municipal_no hr_organization_information.org_information1%TYPE ;
155: l_industry_status hr_organization_information.org_information1%TYPE ;
156: l_tax_office_name hr_organization_units.name%TYPE ;
157: l_tax_office_id hr_organization_information.organization_id%TYPE ;
158:
159: l_address_line_1 hr_locations.address_line_1%TYPE ;
160: l_address_line_2 hr_locations.address_line_2%TYPE ;
161: l_address_line_3 hr_locations.address_line_3%TYPE ;

Line 165: l_phone hr_organization_information.org_information1%TYPE ;

161: l_address_line_3 hr_locations.address_line_3%TYPE ;
162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:
165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;
167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;

Line 166: l_email hr_organization_information.org_information1%TYPE ;

162: l_postal_code hr_locations.postal_code%TYPE ;
163: l_postal_office hr_locations.postal_code%TYPE ;
164:
165: l_phone hr_organization_information.org_information1%TYPE ;
166: l_email hr_organization_information.org_information1%TYPE ;
167:
168: l_taddress_line_1 hr_locations.address_line_1%TYPE ;
169: l_taddress_line_2 hr_locations.address_line_2%TYPE ;
170: l_taddress_line_3 hr_locations.address_line_3%TYPE ;

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

227:
228:
229: /* Cursors */
230:
231: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
232: IS
233: SELECT o1.name , hoi2.ORG_INFORMATION4
234: FROM hr_organization_units o1
235: , hr_organization_information hoi1

Line 235: , hr_organization_information hoi1

231: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
232: IS
233: SELECT o1.name , hoi2.ORG_INFORMATION4
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 o1.name , hoi2.ORG_INFORMATION4
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 = 'NO_LOCAL_UNIT'

Line 247: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

243: AND hoi2.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNIT_DETAILS';
244:
245: rg_Local_Unit_Details csr_Local_Unit_Details%rowtype;
246:
247: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
248: IS
249: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2 , hoi2.ORG_INFORMATION3 , hoi2.ORG_INFORMATION5
250: FROM hr_organization_units o1
251: , hr_organization_information hoi1

Line 251: , hr_organization_information hoi1

247: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
248: IS
249: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2 , hoi2.ORG_INFORMATION3 , hoi2.ORG_INFORMATION5
250: FROM hr_organization_units o1
251: , hr_organization_information hoi1
252: , hr_organization_information hoi2
253: WHERE o1.business_group_id =l_business_group_id
254: AND hoi1.organization_id = o1.organization_id
255: AND hoi1.organization_id = csr_v_legal_emp_id

Line 252: , hr_organization_information hoi2

248: IS
249: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2 , hoi2.ORG_INFORMATION3 , hoi2.ORG_INFORMATION5
250: FROM hr_organization_units o1
251: , hr_organization_information hoi1
252: , hr_organization_information hoi2
253: WHERE o1.business_group_id =l_business_group_id
254: AND hoi1.organization_id = o1.organization_id
255: AND hoi1.organization_id = csr_v_legal_emp_id
256: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 264: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

260:
261:
262: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
263:
264: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
265: IS
266: SELECT hoi2.ORG_INFORMATION2 email , hoi3.ORG_INFORMATION2 phone
267: FROM hr_organization_units o1
268: , hr_organization_information hoi1

Line 268: , hr_organization_information hoi1

264: Cursor csr_Legal_Emp_Contact ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
265: IS
266: SELECT hoi2.ORG_INFORMATION2 email , hoi3.ORG_INFORMATION2 phone
267: FROM hr_organization_units o1
268: , hr_organization_information hoi1
269: , hr_organization_information hoi2
270: , hr_organization_information hoi3
271: WHERE o1.business_group_id =l_business_group_id
272: AND hoi1.organization_id = o1.organization_id

Line 269: , hr_organization_information hoi2

265: IS
266: SELECT hoi2.ORG_INFORMATION2 email , hoi3.ORG_INFORMATION2 phone
267: FROM hr_organization_units o1
268: , hr_organization_information hoi1
269: , hr_organization_information hoi2
270: , hr_organization_information hoi3
271: WHERE o1.business_group_id =l_business_group_id
272: AND hoi1.organization_id = o1.organization_id
273: AND hoi1.organization_id = csr_v_legal_emp_id

Line 270: , hr_organization_information hoi3

266: SELECT hoi2.ORG_INFORMATION2 email , hoi3.ORG_INFORMATION2 phone
267: FROM hr_organization_units o1
268: , hr_organization_information hoi1
269: , hr_organization_information hoi2
270: , hr_organization_information hoi3
271: WHERE o1.business_group_id =l_business_group_id
272: AND hoi1.organization_id = o1.organization_id
273: AND hoi1.organization_id = csr_v_legal_emp_id
274: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 285: Cursor csr_Legal_Emp_addr ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

281: AND hoi3.org_information1 (+) = 'PHONE' ;
282:
283: rg_Legal_Emp_Contact csr_Legal_Emp_Contact%rowtype;
284:
285: Cursor csr_Legal_Emp_addr ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
286: IS
287: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
288: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) , LENGTH(hlu.MEANING) -(INSTR(hlu.MEANING,' ', 1,1) -1) ) POSTAL_OFFICE
289: FROM hr_organization_units o1

Line 291: ,hr_organization_information hoi2

287: SELECT hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
288: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) , LENGTH(hlu.MEANING) -(INSTR(hlu.MEANING,' ', 1,1) -1) ) POSTAL_OFFICE
289: FROM hr_organization_units o1
290: , hr_locations hoi1
291: ,hr_organization_information hoi2
292: ,hr_lookups hlu
293: WHERE o1.business_group_id = l_business_group_id
294: AND hoi1.location_id = o1.location_id
295: AND hoi2.organization_id = o1.organization_id

Line 308: Cursor csr_Tax_Office_Details ( csr_v_tax_office_id hr_organization_information.ORGANIZATION_ID%TYPE)

304:
305: rg_Legal_Emp_addr csr_Legal_Emp_addr%rowtype;
306:
307:
308: Cursor csr_Tax_Office_Details ( csr_v_tax_office_id hr_organization_information.ORGANIZATION_ID%TYPE)
309: IS
310: SELECT o1.name , hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
311: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) ) POSTAL_OFFICE
312: FROM hr_organization_units o1

Line 314: ,hr_organization_information hoi2

310: SELECT o1.name , hoi1.ADDRESS_LINE_1 , hoi1.ADDRESS_LINE_2 , hoi1.ADDRESS_LINE_3 ,
311: hoi1.POSTAL_CODE , SUBSTR(hlu.MEANING , INSTR(hlu.MEANING,' ', 1,1) ) POSTAL_OFFICE
312: FROM hr_organization_units o1
313: , hr_locations hoi1
314: ,hr_organization_information hoi2
315: ,hr_lookups hlu
316: WHERE o1.business_group_id = l_business_group_id
317: AND hoi1.location_id = o1.location_id
318: AND hoi2.organization_id = o1.organization_id

Line 370: , hr_organization_information hoi1

366: AND hsck.SOFT_CODING_KEYFLEX_ID=as1.SOFT_CODING_KEYFLEX_ID
367: AND EXISTS
368: ( SELECT hoi1.organization_id
369: FROM hr_organization_units o1
370: , hr_organization_information hoi1
371: , hr_organization_information hoi2
372: , hr_organization_information hoi3
373: , hr_organization_information hoi4
374: WHERE hoi1.organization_id = o1.organization_id

Line 371: , hr_organization_information hoi2

367: AND EXISTS
368: ( SELECT hoi1.organization_id
369: FROM hr_organization_units o1
370: , hr_organization_information hoi1
371: , hr_organization_information hoi2
372: , hr_organization_information hoi3
373: , hr_organization_information hoi4
374: WHERE hoi1.organization_id = o1.organization_id
375: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 372: , hr_organization_information hoi3

368: ( SELECT hoi1.organization_id
369: FROM hr_organization_units o1
370: , hr_organization_information hoi1
371: , hr_organization_information hoi2
372: , hr_organization_information hoi3
373: , hr_organization_information hoi4
374: WHERE hoi1.organization_id = o1.organization_id
375: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
376: AND hoi1.org_information_context = 'CLASS'

Line 373: , hr_organization_information hoi4

369: FROM hr_organization_units o1
370: , hr_organization_information hoi1
371: , hr_organization_information hoi2
372: , hr_organization_information hoi3
373: , hr_organization_information hoi4
374: WHERE hoi1.organization_id = o1.organization_id
375: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
376: AND hoi1.org_information_context = 'CLASS'
377: AND o1.organization_id = hoi2.org_information1

Line 488: , hr_organization_information hoi1

484: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER )
485: IS
486: SELECT hoi1.organization_id
487: FROM hr_organization_units o1
488: , hr_organization_information hoi1
489: , hr_organization_information hoi2
490: , hr_organization_information hoi3
491: , hr_organization_information hoi4
492: WHERE hoi1.organization_id = o1.organization_id

Line 489: , hr_organization_information hoi2

485: IS
486: SELECT hoi1.organization_id
487: FROM hr_organization_units o1
488: , hr_organization_information hoi1
489: , hr_organization_information hoi2
490: , hr_organization_information hoi3
491: , hr_organization_information hoi4
492: WHERE hoi1.organization_id = o1.organization_id
493: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 490: , hr_organization_information hoi3

486: SELECT hoi1.organization_id
487: FROM hr_organization_units o1
488: , hr_organization_information hoi1
489: , hr_organization_information hoi2
490: , hr_organization_information hoi3
491: , hr_organization_information hoi4
492: WHERE hoi1.organization_id = o1.organization_id
493: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
494: AND hoi1.org_information_context = 'CLASS'

Line 491: , hr_organization_information hoi4

487: FROM hr_organization_units o1
488: , hr_organization_information hoi1
489: , hr_organization_information hoi2
490: , hr_organization_information hoi3
491: , hr_organization_information hoi4
492: WHERE hoi1.organization_id = o1.organization_id
493: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
494: AND hoi1.org_information_context = 'CLASS'
495: AND o1.organization_id = hoi2.org_information1

Line 512: Cursor csr_Local_Unit_EL ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)

508: FROM ff_globals_f
509: WHERE global_name = p_global_name
510: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
511:
512: Cursor csr_Local_Unit_EL ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
513: IS
514: SELECT hoi2.org_information1
515: FROM hr_organization_units o1
516: , hr_organization_information hoi1

Line 516: , hr_organization_information hoi1

512: Cursor csr_Local_Unit_EL ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
513: IS
514: SELECT hoi2.org_information1
515: FROM hr_organization_units o1
516: , hr_organization_information hoi1
517: , hr_organization_information hoi2
518: WHERE o1.business_group_id =l_business_group_id
519: AND hoi1.organization_id = o1.organization_id
520: AND hoi1.organization_id = csr_v_local_unit_id

Line 517: , hr_organization_information hoi2

513: IS
514: SELECT hoi2.org_information1
515: FROM hr_organization_units o1
516: , hr_organization_information hoi1
517: , hr_organization_information hoi2
518: WHERE o1.business_group_id =l_business_group_id
519: AND hoi1.organization_id = o1.organization_id
520: AND hoi1.organization_id = csr_v_local_unit_id
521: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 530: Cursor csr_Legal_Emp_EL( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)

526: AND fnd_date.canonical_to_date(hoi2.org_information3);
527:
528: rg_Local_Unit_EL csr_Local_Unit_EL%rowtype;
529:
530: Cursor csr_Legal_Emp_EL( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
531: IS
532: SELECT hoi2.org_information1
533: FROM hr_organization_units o1
534: , hr_organization_information hoi1

Line 534: , hr_organization_information hoi1

530: Cursor csr_Legal_Emp_EL( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE, p_date_earned DATE)
531: IS
532: SELECT hoi2.org_information1
533: FROM hr_organization_units o1
534: , hr_organization_information hoi1
535: , hr_organization_information hoi2
536: WHERE o1.business_group_id =l_business_group_id
537: AND hoi1.organization_id = o1.organization_id
538: AND hoi1.organization_id = csr_v_legal_emp_id

Line 535: , hr_organization_information hoi2

531: IS
532: SELECT hoi2.org_information1
533: FROM hr_organization_units o1
534: , hr_organization_information hoi1
535: , hr_organization_information hoi2
536: WHERE o1.business_group_id =l_business_group_id
537: AND hoi1.organization_id = o1.organization_id
538: AND hoi1.organization_id = csr_v_legal_emp_id
539: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'