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

Line 310: l_municipal_no hr_organization_information.org_information1%TYPE ;

306: l_reporting_end_date DATE;
307: l_municipal_name VARCHAR2(30);
308: l_zone NUMBER;
309:
310: l_municipal_no hr_organization_information.org_information1%TYPE ;
311: l_industry_status hr_organization_information.org_information1%TYPE ;
312: l_nace_code hr_organization_information.org_information1%TYPE ;
313: l_lu_name hr_organization_units.name%TYPE ;
314: l_Witholding_Tax NUMBER;

Line 311: l_industry_status hr_organization_information.org_information1%TYPE ;

307: l_municipal_name VARCHAR2(30);
308: l_zone NUMBER;
309:
310: l_municipal_no hr_organization_information.org_information1%TYPE ;
311: l_industry_status hr_organization_information.org_information1%TYPE ;
312: l_nace_code hr_organization_information.org_information1%TYPE ;
313: l_lu_name hr_organization_units.name%TYPE ;
314: l_Witholding_Tax NUMBER;
315: l_sum_tax_value NUMBER;

Line 312: l_nace_code hr_organization_information.org_information1%TYPE ;

308: l_zone NUMBER;
309:
310: l_municipal_no hr_organization_information.org_information1%TYPE ;
311: l_industry_status hr_organization_information.org_information1%TYPE ;
312: l_nace_code hr_organization_information.org_information1%TYPE ;
313: l_lu_name hr_organization_units.name%TYPE ;
314: l_Witholding_Tax NUMBER;
315: l_sum_tax_value NUMBER;
316: l_tax_value NUMBER;

Line 340: Cursor csr_LU_Details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE) IS

336: --
337: l_counter NUMBER;
338: l_status NUMBER;
339: --
340: Cursor csr_LU_Details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE) IS
341: SELECT o1.name lu_name
342: ,hoi2.org_information4 industry_status
343: ,hoi2.org_information2 nace_code
344: ,hoi2.org_information1 org_num

Line 347: ,hr_organization_information hoi1

343: ,hoi2.org_information2 nace_code
344: ,hoi2.org_information1 org_num
345: ,hoi2.org_information6 municipal_no
346: FROM hr_organization_units o1
347: ,hr_organization_information hoi1
348: ,hr_organization_information hoi2
349: WHERE o1.business_group_id = l_business_group_id
350: AND hoi1.organization_id = o1.organization_id
351: AND hoi1.organization_id = csr_v_local_unit_id

Line 348: ,hr_organization_information hoi2

344: ,hoi2.org_information1 org_num
345: ,hoi2.org_information6 municipal_no
346: FROM hr_organization_units o1
347: ,hr_organization_information hoi1
348: ,hr_organization_information hoi2
349: WHERE o1.business_group_id = l_business_group_id
350: AND hoi1.organization_id = o1.organization_id
351: AND hoi1.organization_id = csr_v_local_unit_id
352: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 359: Cursor csr_LE_Details (csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS

355: AND hoi2.org_information_context = 'NO_LOCAL_UNIT_DETAILS';
356: --
357: rg_LU_Details csr_LU_Details%rowtype;
358: --
359: Cursor csr_LE_Details (csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
360: SELECT o1.name le_name
361: ,hoi2.org_information1 org_number
362: ,hoi2.org_information2 municipal_no
363: ,hoi2.org_information3 industry_status

Line 367: ,hr_organization_information hoi1

363: ,hoi2.org_information3 industry_status
364: ,hoi2.org_information4 nace_code
365: -- ,hoi2.org_information5 tax_off
366: FROM hr_organization_units o1
367: ,hr_organization_information hoi1
368: ,hr_organization_information hoi2
369: WHERE o1.business_group_id = l_business_group_id
370: AND hoi1.organization_id = o1.organization_id
371: AND hoi1.organization_id = csr_v_legal_emp_id

Line 368: ,hr_organization_information hoi2

364: ,hoi2.org_information4 nace_code
365: -- ,hoi2.org_information5 tax_off
366: FROM hr_organization_units o1
367: ,hr_organization_information hoi1
368: ,hr_organization_information hoi2
369: WHERE o1.business_group_id = l_business_group_id
370: AND hoi1.organization_id = o1.organization_id
371: AND hoi1.organization_id = csr_v_legal_emp_id
372: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 379: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS

375: AND hoi2.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS' ;
376: --
377: rg_LE_Details csr_LE_Details%rowtype;
378: --
379: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
380: SELECT hoi2.org_information2 email
381: ,hoi3.org_information2 phone
382: FROM hr_organization_units o1
383: ,hr_organization_information hoi1

Line 383: ,hr_organization_information hoi1

379: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
380: SELECT hoi2.org_information2 email
381: ,hoi3.org_information2 phone
382: FROM hr_organization_units o1
383: ,hr_organization_information hoi1
384: ,hr_organization_information hoi2
385: ,hr_organization_information hoi3
386: WHERE o1.business_group_id = l_business_group_id
387: AND hoi1.organization_id = o1.organization_id

Line 384: ,hr_organization_information hoi2

380: SELECT hoi2.org_information2 email
381: ,hoi3.org_information2 phone
382: FROM hr_organization_units o1
383: ,hr_organization_information hoi1
384: ,hr_organization_information hoi2
385: ,hr_organization_information hoi3
386: WHERE o1.business_group_id = l_business_group_id
387: AND hoi1.organization_id = o1.organization_id
388: AND hoi1.organization_id = csr_v_legal_emp_id

Line 385: ,hr_organization_information hoi3

381: ,hoi3.org_information2 phone
382: FROM hr_organization_units o1
383: ,hr_organization_information hoi1
384: ,hr_organization_information hoi2
385: ,hr_organization_information hoi3
386: WHERE o1.business_group_id = l_business_group_id
387: AND hoi1.organization_id = o1.organization_id
388: AND hoi1.organization_id = csr_v_legal_emp_id
389: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 400: Cursor csr_LE_addr ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS

396: AND hoi3.org_information1(+) = 'PHONE';
397: --
398: rg_LE_Contact csr_LE_Contact%rowtype;
399: --
400: Cursor csr_LE_addr ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
401: SELECT hoi1.address_line_1 address_line_1
402: ,hoi1.address_line_2 address_line_2
403: ,hoi1.address_line_3 address_line_3
404: ,hoi1.postal_code postal_code

Line 408: ,hr_organization_information hoi2

404: ,hoi1.postal_code postal_code
405: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
406: FROM hr_organization_units o1
407: ,hr_locations hoi1
408: ,hr_organization_information hoi2
409: ,hr_lookups hlu
410: WHERE o1.business_group_id = l_business_group_id
411: AND hoi1.location_id = o1.location_id
412: AND hoi2.organization_id = o1.organization_id

Line 456: ,hr_organization_information hoi1

452: AND act.TAX_UNIT_ID = p_legal_employer_id
453: AND hsck.SOFT_CODING_KEYFLEX_ID = as1.SOFT_CODING_KEYFLEX_ID
454: AND EXISTS (SELECT hoi1.organization_id
455: FROM hr_organization_units o1
456: ,hr_organization_information hoi1
457: ,hr_organization_information hoi2
458: ,hr_organization_information hoi3
459: ,hr_organization_information hoi4
460: WHERE hoi1.organization_id = o1.organization_id

Line 457: ,hr_organization_information hoi2

453: AND hsck.SOFT_CODING_KEYFLEX_ID = as1.SOFT_CODING_KEYFLEX_ID
454: AND EXISTS (SELECT hoi1.organization_id
455: FROM hr_organization_units o1
456: ,hr_organization_information hoi1
457: ,hr_organization_information hoi2
458: ,hr_organization_information hoi3
459: ,hr_organization_information hoi4
460: WHERE hoi1.organization_id = o1.organization_id
461: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 458: ,hr_organization_information hoi3

454: AND EXISTS (SELECT hoi1.organization_id
455: FROM hr_organization_units o1
456: ,hr_organization_information hoi1
457: ,hr_organization_information hoi2
458: ,hr_organization_information hoi3
459: ,hr_organization_information hoi4
460: WHERE hoi1.organization_id = o1.organization_id
461: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
462: AND hoi1.org_information_context = 'CLASS'

Line 459: ,hr_organization_information hoi4

455: FROM hr_organization_units o1
456: ,hr_organization_information hoi1
457: ,hr_organization_information hoi2
458: ,hr_organization_information hoi3
459: ,hr_organization_information hoi4
460: WHERE hoi1.organization_id = o1.organization_id
461: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
462: AND hoi1.org_information_context = 'CLASS'
463: AND o1.organization_id = hoi2.org_information1

Line 557: ,hr_organization_information hoi1

553: --
554: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER) IS
555: SELECT hoi1.organization_id lu_id
556: FROM hr_organization_units o1
557: ,hr_organization_information hoi1
558: ,hr_organization_information hoi2
559: ,hr_organization_information hoi3
560: ,hr_organization_information hoi4
561: WHERE hoi1.organization_id = o1.organization_id

Line 558: ,hr_organization_information hoi2

554: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER) IS
555: SELECT hoi1.organization_id lu_id
556: FROM hr_organization_units o1
557: ,hr_organization_information hoi1
558: ,hr_organization_information hoi2
559: ,hr_organization_information hoi3
560: ,hr_organization_information hoi4
561: WHERE hoi1.organization_id = o1.organization_id
562: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 559: ,hr_organization_information hoi3

555: SELECT hoi1.organization_id lu_id
556: FROM hr_organization_units o1
557: ,hr_organization_information hoi1
558: ,hr_organization_information hoi2
559: ,hr_organization_information hoi3
560: ,hr_organization_information hoi4
561: WHERE hoi1.organization_id = o1.organization_id
562: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
563: AND hoi1.org_information_context = 'CLASS'

Line 560: ,hr_organization_information hoi4

556: FROM hr_organization_units o1
557: ,hr_organization_information hoi1
558: ,hr_organization_information hoi2
559: ,hr_organization_information hoi3
560: ,hr_organization_information hoi4
561: WHERE hoi1.organization_id = o1.organization_id
562: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
563: AND hoi1.org_information_context = 'CLASS'
564: AND o1.organization_id = hoi2.org_information1

Line 574: CURSOR csr_Local_Unit_EA(csr_v_local_unit_id hr_organization_information.organization_id%TYPE

570: AND hoi1.organization_id = hoi4.organization_id
571: AND hoi4.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
572: AND hoi4.org_information5 = 'N';
573: --
574: CURSOR csr_Local_Unit_EA(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
575: ,p_date_earned DATE) IS
576: SELECT to_number(hoi2.org_information4)
577: FROM hr_organization_units o1
578: ,hr_organization_information hoi1

Line 578: ,hr_organization_information hoi1

574: CURSOR csr_Local_Unit_EA(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
575: ,p_date_earned DATE) IS
576: SELECT to_number(hoi2.org_information4)
577: FROM hr_organization_units o1
578: ,hr_organization_information hoi1
579: ,hr_organization_information hoi2
580: WHERE o1.business_group_id = l_business_group_id
581: AND hoi1.organization_id = o1.organization_id
582: AND hoi1.organization_id = csr_v_local_unit_id

Line 579: ,hr_organization_information hoi2

575: ,p_date_earned DATE) IS
576: SELECT to_number(hoi2.org_information4)
577: FROM hr_organization_units o1
578: ,hr_organization_information hoi1
579: ,hr_organization_information hoi2
580: WHERE o1.business_group_id = l_business_group_id
581: AND hoi1.organization_id = o1.organization_id
582: AND hoi1.organization_id = csr_v_local_unit_id
583: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 590: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

586: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
587: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
588: AND fnd_date.canonical_to_date(hoi2.org_information3);
589: --
590: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
591: ,p_date_earned DATE) IS
592: SELECT to_number(hoi2.org_information4)
593: FROM hr_organization_units o1
594: ,hr_organization_information hoi1

Line 594: ,hr_organization_information hoi1

590: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
591: ,p_date_earned DATE) IS
592: SELECT to_number(hoi2.org_information4)
593: FROM hr_organization_units o1
594: ,hr_organization_information hoi1
595: ,hr_organization_information hoi2
596: WHERE o1.business_group_id = l_business_group_id
597: AND hoi1.organization_id = o1.organization_id
598: AND hoi1.organization_id = csr_v_legal_emp_id

Line 595: ,hr_organization_information hoi2

591: ,p_date_earned DATE) IS
592: SELECT to_number(hoi2.org_information4)
593: FROM hr_organization_units o1
594: ,hr_organization_information hoi1
595: ,hr_organization_information hoi2
596: WHERE o1.business_group_id = l_business_group_id
597: AND hoi1.organization_id = o1.organization_id
598: AND hoi1.organization_id = csr_v_legal_emp_id
599: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 606: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE

602: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
603: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
604: AND fnd_date.canonical_to_date(hoi2.org_information3);
605: --
606: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
607: ,p_date_earned DATE) IS
608: SELECT SUM(hoi2.org_information1) exempt_limit
609: ,SUM(hoi2.org_information4) economic_aid
610: FROM hr_organization_units o1

Line 611: ,hr_organization_information hoi1

607: ,p_date_earned DATE) IS
608: SELECT SUM(hoi2.org_information1) exempt_limit
609: ,SUM(hoi2.org_information4) economic_aid
610: FROM hr_organization_units o1
611: ,hr_organization_information hoi1
612: ,hr_organization_information hoi2
613: WHERE o1.business_group_id = l_business_group_id
614: AND hoi1.organization_id = o1.organization_id
615: AND hoi1.organization_id = csr_v_local_unit_id

Line 612: ,hr_organization_information hoi2

608: SELECT SUM(hoi2.org_information1) exempt_limit
609: ,SUM(hoi2.org_information4) economic_aid
610: FROM hr_organization_units o1
611: ,hr_organization_information hoi1
612: ,hr_organization_information hoi2
613: WHERE o1.business_group_id = l_business_group_id
614: AND hoi1.organization_id = o1.organization_id
615: AND hoi1.organization_id = csr_v_local_unit_id
616: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 625: Cursor csr_Legal_Emp_EL(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

621: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
622: --
623: rg_Local_Unit_EL csr_Local_Unit_EL%ROWTYPE;
624: --
625: Cursor csr_Legal_Emp_EL(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
626: ,p_date_earned DATE) IS
627: SELECT SUM(hoi2.org_information1) exempt_limit
628: ,SUM(hoi2.org_information4) economic_aid
629: FROM hr_organization_units o1

Line 630: ,hr_organization_information hoi1

626: ,p_date_earned DATE) IS
627: SELECT SUM(hoi2.org_information1) exempt_limit
628: ,SUM(hoi2.org_information4) economic_aid
629: FROM hr_organization_units o1
630: ,hr_organization_information hoi1
631: ,hr_organization_information hoi2
632: WHERE o1.business_group_id = l_business_group_id
633: AND hoi1.organization_id = o1.organization_id
634: AND hoi1.organization_id = csr_v_legal_emp_id

Line 631: ,hr_organization_information hoi2

627: SELECT SUM(hoi2.org_information1) exempt_limit
628: ,SUM(hoi2.org_information4) economic_aid
629: FROM hr_organization_units o1
630: ,hr_organization_information hoi1
631: ,hr_organization_information hoi2
632: WHERE o1.business_group_id = l_business_group_id
633: AND hoi1.organization_id = o1.organization_id
634: AND hoi1.organization_id = csr_v_legal_emp_id
635: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 644: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE

640: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
641: --
642: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
643: --
644: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
645: ,p_date_earned DATE) IS
646: SELECT SUM(hoi2.org_information4) economic_aid
647: FROM hr_organization_units o1
648: ,hr_organization_information hoi1

Line 648: ,hr_organization_information hoi1

644: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
645: ,p_date_earned DATE) IS
646: SELECT SUM(hoi2.org_information4) economic_aid
647: FROM hr_organization_units o1
648: ,hr_organization_information hoi1
649: ,hr_organization_information hoi2
650: WHERE o1.business_group_id = l_business_group_id
651: AND hoi1.organization_id = o1.organization_id
652: AND hoi1.organization_id = csr_v_local_unit_id

Line 649: ,hr_organization_information hoi2

645: ,p_date_earned DATE) IS
646: SELECT SUM(hoi2.org_information4) economic_aid
647: FROM hr_organization_units o1
648: ,hr_organization_information hoi1
649: ,hr_organization_information hoi2
650: WHERE o1.business_group_id = l_business_group_id
651: AND hoi1.organization_id = o1.organization_id
652: AND hoi1.organization_id = csr_v_local_unit_id
653: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 662: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

658: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
659: --
660: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
661: --
662: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
663: ,p_date_earned DATE) IS
664: SELECT SUM(hoi2.org_information4) economic_aid
665: FROM hr_organization_units o1
666: ,hr_organization_information hoi1

Line 666: ,hr_organization_information hoi1

662: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
663: ,p_date_earned DATE) IS
664: SELECT SUM(hoi2.org_information4) economic_aid
665: FROM hr_organization_units o1
666: ,hr_organization_information hoi1
667: ,hr_organization_information hoi2
668: WHERE o1.business_group_id = l_business_group_id
669: AND hoi1.organization_id = o1.organization_id
670: AND hoi1.organization_id = csr_v_legal_emp_id

Line 667: ,hr_organization_information hoi2

663: ,p_date_earned DATE) IS
664: SELECT SUM(hoi2.org_information4) economic_aid
665: FROM hr_organization_units o1
666: ,hr_organization_information hoi1
667: ,hr_organization_information hoi2
668: WHERE o1.business_group_id = l_business_group_id
669: AND hoi1.organization_id = o1.organization_id
670: AND hoi1.organization_id = csr_v_legal_emp_id
671: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'