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_UNITS

Line 313: l_lu_name hr_organization_units.name%TYPE ;

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;
317: l_def_bal_id NUMBER;

Line 346: FROM hr_organization_units o1

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

Line 366: FROM hr_organization_units o1

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

Line 382: FROM hr_organization_units o1

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
384: ,hr_organization_information hoi2
385: ,hr_organization_information hoi3
386: WHERE o1.business_group_id = l_business_group_id

Line 406: FROM hr_organization_units o1

402: ,hoi1.address_line_2 address_line_2
403: ,hoi1.address_line_3 address_line_3
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

Line 455: FROM hr_organization_units o1

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

Line 556: FROM hr_organization_units o1

552: rg_get_mun_dtls csr_get_mun_dtls%ROWTYPE;
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

Line 577: FROM hr_organization_units o1

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
579: ,hr_organization_information hoi2
580: WHERE o1.business_group_id = l_business_group_id
581: AND hoi1.organization_id = o1.organization_id

Line 593: FROM hr_organization_units o1

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
595: ,hr_organization_information hoi2
596: WHERE o1.business_group_id = l_business_group_id
597: AND hoi1.organization_id = o1.organization_id

Line 610: FROM hr_organization_units o1

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

Line 629: FROM hr_organization_units o1

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

Line 647: FROM hr_organization_units o1

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
649: ,hr_organization_information hoi2
650: WHERE o1.business_group_id = l_business_group_id
651: AND hoi1.organization_id = o1.organization_id

Line 665: FROM hr_organization_units o1

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
667: ,hr_organization_information hoi2
668: WHERE o1.business_group_id = l_business_group_id
669: AND hoi1.organization_id = o1.organization_id