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 321: l_municipal_no hr_organization_information.org_information1%TYPE ;

317: l_reporting_end_date DATE;
318: l_municipal_name VARCHAR2(30);
319: l_zone NUMBER;
320:
321: l_municipal_no hr_organization_information.org_information1%TYPE ;
322: l_industry_status hr_organization_information.org_information1%TYPE ;
323: l_nace_code hr_organization_information.org_information1%TYPE ;
324: l_lu_name hr_organization_units.name%TYPE ;
325: l_Witholding_Tax NUMBER;

Line 322: l_industry_status hr_organization_information.org_information1%TYPE ;

318: l_municipal_name VARCHAR2(30);
319: l_zone NUMBER;
320:
321: l_municipal_no hr_organization_information.org_information1%TYPE ;
322: l_industry_status hr_organization_information.org_information1%TYPE ;
323: l_nace_code hr_organization_information.org_information1%TYPE ;
324: l_lu_name hr_organization_units.name%TYPE ;
325: l_Witholding_Tax NUMBER;
326: l_sum_tax_value NUMBER;

Line 323: l_nace_code hr_organization_information.org_information1%TYPE ;

319: l_zone NUMBER;
320:
321: l_municipal_no hr_organization_information.org_information1%TYPE ;
322: l_industry_status hr_organization_information.org_information1%TYPE ;
323: l_nace_code hr_organization_information.org_information1%TYPE ;
324: l_lu_name hr_organization_units.name%TYPE ;
325: l_Witholding_Tax NUMBER;
326: l_sum_tax_value NUMBER;
327: l_sum_tax_value_rep NUMBER; --14260836

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

350: --
351: l_counter NUMBER;
352: l_status NUMBER;
353: --
354: Cursor csr_LU_Details (csr_v_local_unit_id hr_organization_information.organization_id%TYPE) IS
355: SELECT o1.name lu_name
356: ,hoi2.org_information4 industry_status
357: ,hoi2.org_information2 nace_code
358: ,hoi2.org_information1 org_num

Line 361: ,hr_organization_information hoi1

357: ,hoi2.org_information2 nace_code
358: ,hoi2.org_information1 org_num
359: ,hoi2.org_information6 municipal_no
360: FROM hr_organization_units o1
361: ,hr_organization_information hoi1
362: ,hr_organization_information hoi2
363: WHERE o1.business_group_id = l_business_group_id
364: AND hoi1.organization_id = o1.organization_id
365: AND hoi1.organization_id = csr_v_local_unit_id

Line 362: ,hr_organization_information hoi2

358: ,hoi2.org_information1 org_num
359: ,hoi2.org_information6 municipal_no
360: FROM hr_organization_units o1
361: ,hr_organization_information hoi1
362: ,hr_organization_information hoi2
363: WHERE o1.business_group_id = l_business_group_id
364: AND hoi1.organization_id = o1.organization_id
365: AND hoi1.organization_id = csr_v_local_unit_id
366: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

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

369: AND hoi2.org_information_context = 'NO_LOCAL_UNIT_DETAILS';
370: --
371: rg_LU_Details csr_LU_Details%rowtype;
372: --
373: Cursor csr_LE_Details (csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
374: SELECT o1.name le_name
375: ,hoi2.org_information1 org_number
376: ,hoi2.org_information2 municipal_no
377: ,hoi2.org_information3 industry_status

Line 381: ,hr_organization_information hoi1

377: ,hoi2.org_information3 industry_status
378: ,hoi2.org_information4 nace_code
379: -- ,hoi2.org_information5 tax_off
380: FROM hr_organization_units o1
381: ,hr_organization_information hoi1
382: ,hr_organization_information hoi2
383: WHERE o1.business_group_id = l_business_group_id
384: AND hoi1.organization_id = o1.organization_id
385: AND hoi1.organization_id = csr_v_legal_emp_id

Line 382: ,hr_organization_information hoi2

378: ,hoi2.org_information4 nace_code
379: -- ,hoi2.org_information5 tax_off
380: FROM hr_organization_units o1
381: ,hr_organization_information hoi1
382: ,hr_organization_information hoi2
383: WHERE o1.business_group_id = l_business_group_id
384: AND hoi1.organization_id = o1.organization_id
385: AND hoi1.organization_id = csr_v_legal_emp_id
386: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

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

389: AND hoi2.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS' ;
390: --
391: rg_LE_Details csr_LE_Details%rowtype;
392: --
393: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
394: SELECT hoi2.org_information2 email
395: ,hoi3.org_information2 phone
396: FROM hr_organization_units o1
397: ,hr_organization_information hoi1

Line 397: ,hr_organization_information hoi1

393: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
394: SELECT hoi2.org_information2 email
395: ,hoi3.org_information2 phone
396: FROM hr_organization_units o1
397: ,hr_organization_information hoi1
398: ,hr_organization_information hoi2
399: ,hr_organization_information hoi3
400: WHERE o1.business_group_id = l_business_group_id
401: AND hoi1.organization_id = o1.organization_id

Line 398: ,hr_organization_information hoi2

394: SELECT hoi2.org_information2 email
395: ,hoi3.org_information2 phone
396: FROM hr_organization_units o1
397: ,hr_organization_information hoi1
398: ,hr_organization_information hoi2
399: ,hr_organization_information hoi3
400: WHERE o1.business_group_id = l_business_group_id
401: AND hoi1.organization_id = o1.organization_id
402: AND hoi1.organization_id = csr_v_legal_emp_id

Line 399: ,hr_organization_information hoi3

395: ,hoi3.org_information2 phone
396: FROM hr_organization_units o1
397: ,hr_organization_information hoi1
398: ,hr_organization_information hoi2
399: ,hr_organization_information hoi3
400: WHERE o1.business_group_id = l_business_group_id
401: AND hoi1.organization_id = o1.organization_id
402: AND hoi1.organization_id = csr_v_legal_emp_id
403: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

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

410: AND hoi3.org_information1(+) = 'PHONE';
411: --
412: rg_LE_Contact csr_LE_Contact%rowtype;
413: --
414: Cursor csr_LE_addr ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
415: SELECT hoi1.address_line_1 address_line_1
416: ,hoi1.address_line_2 address_line_2
417: ,hoi1.address_line_3 address_line_3
418: ,hoi1.postal_code postal_code

Line 422: ,hr_organization_information hoi2

418: ,hoi1.postal_code postal_code
419: ,SUBSTR(hlu.meaning, INSTR(hlu.meaning,' ', 1,1), LENGTH(hlu.meaning)-(INSTR(hlu.meaning,' ', 1,1)-1)) postal_office
420: FROM hr_organization_units o1
421: ,hr_locations hoi1
422: ,hr_organization_information hoi2
423: ,hr_lookups hlu
424: WHERE o1.business_group_id = l_business_group_id
425: AND hoi1.location_id = o1.location_id
426: AND hoi2.organization_id = o1.organization_id

Line 470: ,hr_organization_information hoi1

466: AND act.TAX_UNIT_ID = p_legal_employer_id
467: AND hsck.SOFT_CODING_KEYFLEX_ID = as1.SOFT_CODING_KEYFLEX_ID
468: AND EXISTS (SELECT hoi1.organization_id
469: FROM hr_organization_units o1
470: ,hr_organization_information hoi1
471: ,hr_organization_information hoi2
472: ,hr_organization_information hoi3
473: ,hr_organization_information hoi4
474: WHERE hoi1.organization_id = o1.organization_id

Line 471: ,hr_organization_information hoi2

467: AND hsck.SOFT_CODING_KEYFLEX_ID = as1.SOFT_CODING_KEYFLEX_ID
468: AND EXISTS (SELECT hoi1.organization_id
469: FROM hr_organization_units o1
470: ,hr_organization_information hoi1
471: ,hr_organization_information hoi2
472: ,hr_organization_information hoi3
473: ,hr_organization_information hoi4
474: WHERE hoi1.organization_id = o1.organization_id
475: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 472: ,hr_organization_information hoi3

468: AND EXISTS (SELECT hoi1.organization_id
469: FROM hr_organization_units o1
470: ,hr_organization_information hoi1
471: ,hr_organization_information hoi2
472: ,hr_organization_information hoi3
473: ,hr_organization_information hoi4
474: WHERE hoi1.organization_id = o1.organization_id
475: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
476: AND hoi1.org_information_context = 'CLASS'

Line 473: ,hr_organization_information hoi4

469: FROM hr_organization_units o1
470: ,hr_organization_information hoi1
471: ,hr_organization_information hoi2
472: ,hr_organization_information hoi3
473: ,hr_organization_information hoi4
474: WHERE hoi1.organization_id = o1.organization_id
475: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
476: AND hoi1.org_information_context = 'CLASS'
477: AND o1.organization_id = hoi2.org_information1

Line 596: ,hr_organization_information hoi1

592: --
593: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER) IS
594: SELECT hoi1.organization_id lu_id
595: FROM hr_organization_units o1
596: ,hr_organization_information hoi1
597: ,hr_organization_information hoi2
598: ,hr_organization_information hoi3
599: ,hr_organization_information hoi4
600: WHERE hoi1.organization_id = o1.organization_id

Line 597: ,hr_organization_information hoi2

593: CURSOR csr_lu_dtls(p_legal_employer_id NUMBER) IS
594: SELECT hoi1.organization_id lu_id
595: FROM hr_organization_units o1
596: ,hr_organization_information hoi1
597: ,hr_organization_information hoi2
598: ,hr_organization_information hoi3
599: ,hr_organization_information hoi4
600: WHERE hoi1.organization_id = o1.organization_id
601: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 598: ,hr_organization_information hoi3

594: SELECT hoi1.organization_id lu_id
595: FROM hr_organization_units o1
596: ,hr_organization_information hoi1
597: ,hr_organization_information hoi2
598: ,hr_organization_information hoi3
599: ,hr_organization_information hoi4
600: WHERE hoi1.organization_id = o1.organization_id
601: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
602: AND hoi1.org_information_context = 'CLASS'

Line 599: ,hr_organization_information hoi4

595: FROM hr_organization_units o1
596: ,hr_organization_information hoi1
597: ,hr_organization_information hoi2
598: ,hr_organization_information hoi3
599: ,hr_organization_information hoi4
600: WHERE hoi1.organization_id = o1.organization_id
601: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'
602: AND hoi1.org_information_context = 'CLASS'
603: AND o1.organization_id = hoi2.org_information1

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

609: AND hoi1.organization_id = hoi4.organization_id
610: AND hoi4.org_information_context = 'NO_LOCAL_UNIT_DETAILS'
611: AND hoi4.org_information5 = 'N';
612: --
613: CURSOR csr_Local_Unit_EA(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
614: ,p_date_earned DATE) IS
615: SELECT to_number(hoi2.org_information4)
616: FROM hr_organization_units o1
617: ,hr_organization_information hoi1

Line 617: ,hr_organization_information hoi1

613: CURSOR csr_Local_Unit_EA(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
614: ,p_date_earned DATE) IS
615: SELECT to_number(hoi2.org_information4)
616: FROM hr_organization_units o1
617: ,hr_organization_information hoi1
618: ,hr_organization_information hoi2
619: WHERE o1.business_group_id = l_business_group_id
620: AND hoi1.organization_id = o1.organization_id
621: AND hoi1.organization_id = csr_v_local_unit_id

Line 618: ,hr_organization_information hoi2

614: ,p_date_earned DATE) IS
615: SELECT to_number(hoi2.org_information4)
616: FROM hr_organization_units o1
617: ,hr_organization_information hoi1
618: ,hr_organization_information hoi2
619: WHERE o1.business_group_id = l_business_group_id
620: AND hoi1.organization_id = o1.organization_id
621: AND hoi1.organization_id = csr_v_local_unit_id
622: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

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

625: AND hoi2.org_information_context = 'NO_NI_EXEMPTION_LIMIT'
626: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
627: AND fnd_date.canonical_to_date(hoi2.org_information3);
628: --
629: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
630: ,p_date_earned DATE) IS
631: SELECT to_number(hoi2.org_information4)
632: FROM hr_organization_units o1
633: ,hr_organization_information hoi1

Line 633: ,hr_organization_information hoi1

629: Cursor csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
630: ,p_date_earned DATE) IS
631: SELECT to_number(hoi2.org_information4)
632: FROM hr_organization_units o1
633: ,hr_organization_information hoi1
634: ,hr_organization_information hoi2
635: WHERE o1.business_group_id = l_business_group_id
636: AND hoi1.organization_id = o1.organization_id
637: AND hoi1.organization_id = csr_v_legal_emp_id

Line 634: ,hr_organization_information hoi2

630: ,p_date_earned DATE) IS
631: SELECT to_number(hoi2.org_information4)
632: FROM hr_organization_units o1
633: ,hr_organization_information hoi1
634: ,hr_organization_information hoi2
635: WHERE o1.business_group_id = l_business_group_id
636: AND hoi1.organization_id = o1.organization_id
637: AND hoi1.organization_id = csr_v_legal_emp_id
638: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

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

641: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
642: AND p_date_earned BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
643: AND fnd_date.canonical_to_date(hoi2.org_information3);
644: --
645: CURSOR csr_Local_Unit_EL(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
646: ,p_date_earned DATE) IS
647: SELECT SUM(hoi2.org_information1) exempt_limit
648: ,SUM(hoi2.org_information4) economic_aid
649: FROM hr_organization_units o1

Line 650: ,hr_organization_information hoi1

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

Line 651: ,hr_organization_information hoi2

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

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

660: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
661: --
662: rg_Local_Unit_EL csr_Local_Unit_EL%ROWTYPE;
663: --
664: Cursor csr_Legal_Emp_EL(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
665: ,p_date_earned DATE) IS
666: SELECT SUM(hoi2.org_information1) exempt_limit
667: ,SUM(hoi2.org_information4) economic_aid
668: FROM hr_organization_units o1

Line 669: ,hr_organization_information hoi1

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

Line 670: ,hr_organization_information hoi2

666: SELECT SUM(hoi2.org_information1) exempt_limit
667: ,SUM(hoi2.org_information4) economic_aid
668: FROM hr_organization_units o1
669: ,hr_organization_information hoi1
670: ,hr_organization_information hoi2
671: WHERE o1.business_group_id = l_business_group_id
672: AND hoi1.organization_id = o1.organization_id
673: AND hoi1.organization_id = csr_v_legal_emp_id
674: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

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

679: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
680: --
681: rg_Legal_Emp_EL csr_Legal_Emp_EL%ROWTYPE;
682: --
683: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
684: ,p_date_earned DATE) IS
685: SELECT SUM(hoi2.org_information4) economic_aid
686: FROM hr_organization_units o1
687: ,hr_organization_information hoi1

Line 687: ,hr_organization_information hoi1

683: CURSOR csr_Local_Unit_EL_after(csr_v_local_unit_id hr_organization_information.organization_id%TYPE
684: ,p_date_earned DATE) IS
685: SELECT SUM(hoi2.org_information4) economic_aid
686: FROM hr_organization_units o1
687: ,hr_organization_information hoi1
688: ,hr_organization_information hoi2
689: WHERE o1.business_group_id = l_business_group_id
690: AND hoi1.organization_id = o1.organization_id
691: AND hoi1.organization_id = csr_v_local_unit_id

Line 688: ,hr_organization_information hoi2

684: ,p_date_earned DATE) IS
685: SELECT SUM(hoi2.org_information4) economic_aid
686: FROM hr_organization_units o1
687: ,hr_organization_information hoi1
688: ,hr_organization_information hoi2
689: WHERE o1.business_group_id = l_business_group_id
690: AND hoi1.organization_id = o1.organization_id
691: AND hoi1.organization_id = csr_v_local_unit_id
692: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

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

697: AND trunc(add_months(p_date_earned,12),'Y') < fnd_date.canonical_to_date(hoi2.org_information3);
698: --
699: rg_Local_Unit_EL_after csr_Local_Unit_EL_after%ROWTYPE;
700: --
701: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
702: ,p_date_earned DATE) IS
703: SELECT SUM(hoi2.org_information4) economic_aid
704: FROM hr_organization_units o1
705: ,hr_organization_information hoi1

Line 705: ,hr_organization_information hoi1

701: Cursor csr_Legal_Emp_EL_after(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
702: ,p_date_earned DATE) IS
703: SELECT SUM(hoi2.org_information4) economic_aid
704: FROM hr_organization_units o1
705: ,hr_organization_information hoi1
706: ,hr_organization_information hoi2
707: WHERE o1.business_group_id = l_business_group_id
708: AND hoi1.organization_id = o1.organization_id
709: AND hoi1.organization_id = csr_v_legal_emp_id

Line 706: ,hr_organization_information hoi2

702: ,p_date_earned DATE) IS
703: SELECT SUM(hoi2.org_information4) economic_aid
704: FROM hr_organization_units o1
705: ,hr_organization_information hoi1
706: ,hr_organization_information hoi2
707: WHERE o1.business_group_id = l_business_group_id
708: AND hoi1.organization_id = o1.organization_id
709: AND hoi1.organization_id = csr_v_legal_emp_id
710: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'