APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_ORGANIZATION_UNITS

Line 324: l_lu_name hr_organization_units.name%TYPE ;

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
328: l_tax_value NUMBER;

Line 360: FROM hr_organization_units o1

356: ,hoi2.org_information4 industry_status
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

Line 380: FROM hr_organization_units o1

376: ,hoi2.org_information2 municipal_no
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

Line 396: FROM hr_organization_units o1

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
398: ,hr_organization_information hoi2
399: ,hr_organization_information hoi3
400: WHERE o1.business_group_id = l_business_group_id

Line 420: FROM hr_organization_units o1

416: ,hoi1.address_line_2 address_line_2
417: ,hoi1.address_line_3 address_line_3
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

Line 469: FROM hr_organization_units o1

465: AND act.TAX_UNIT_ID = act1.TAX_UNIT_ID
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

Line 595: FROM hr_organization_units o1

591: rg_get_mun_dtls1 csr_get_mun_dtls%ROWTYPE; --14260836
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

Line 616: FROM hr_organization_units o1

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
618: ,hr_organization_information hoi2
619: WHERE o1.business_group_id = l_business_group_id
620: AND hoi1.organization_id = o1.organization_id

Line 632: FROM hr_organization_units o1

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
634: ,hr_organization_information hoi2
635: WHERE o1.business_group_id = l_business_group_id
636: AND hoi1.organization_id = o1.organization_id

Line 649: FROM hr_organization_units o1

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
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

Line 668: FROM hr_organization_units o1

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
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

Line 686: FROM hr_organization_units o1

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
688: ,hr_organization_information hoi2
689: WHERE o1.business_group_id = l_business_group_id
690: AND hoi1.organization_id = o1.organization_id

Line 704: FROM hr_organization_units o1

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
706: ,hr_organization_information hoi2
707: WHERE o1.business_group_id = l_business_group_id
708: AND hoi1.organization_id = o1.organization_id