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

Line 1410: hr_organization_information hoi

1406: e.classification_id,
1407: e.element_information1 earnings_category
1408: FROM PAY_ELEMENT_CLASSIFICATIONS c,
1409: PAY_ELEMENT_TYPES_F e,
1410: hr_organization_information hoi
1411: WHERE e.element_name = p_element_type
1412: AND (e.business_group_id = p_bg_id
1413: OR e.business_group_id IS NULL
1414: )

Line 2542: hr_organization_information hoi

2538: cursor get_element_details (p_element_type in varchar2,p_bg_id in number) is
2539: SELECT c.classification_name
2540: FROM PAY_ELEMENT_CLASSIFICATIONS c,
2541: PAY_ELEMENT_TYPES_F e,
2542: hr_organization_information hoi
2543: WHERE e.classification_id = c.classification_id
2544: AND hoi.organization_id = p_bg_id
2545: AND e.element_name = p_element_type
2546: AND (e.business_group_id = p_bg_id

Line 2594: from hr_organization_information hoi

2590: CURSOR c_get_tax_group IS
2591: select decode(hoi.org_information5,
2592: NULL,'NOT_ENTERED',
2593: hoi.org_information5)
2594: from hr_organization_information hoi
2595: where hoi.organization_id = p_tax_unit_id
2596: and hoi.org_information_context = 'Federal Tax Rules'
2597: ;
2598:

Line 2627: from hr_organization_information hoi,

2623:
2624: Cursor c_get_futa_self_adjust_method
2625: IS
2626: select hl.meaning
2627: from hr_organization_information hoi,
2628: hr_lookups hl
2629: where hoi.organization_id = p_tax_unit_id
2630: and hoi.org_information_context = 'Federal Tax Rules'
2631: and hoi.org_information3 = hl.LOOKUP_CODE

Line 2637: from hr_organization_information hoi,

2633:
2634: Cursor c_get_ss_self_adjust_method
2635: IS
2636: select hl.meaning
2637: from hr_organization_information hoi,
2638: hr_lookups hl
2639: where hoi.organization_id = p_tax_unit_id
2640: and hoi.org_information_context = 'Federal Tax Rules'
2641: and hoi.org_information1 = hl.LOOKUP_CODE

Line 2647: from hr_organization_information hoi,

2643:
2644: Cursor c_get_medi_self_adjust_method
2645: IS
2646: select hl.meaning
2647: from hr_organization_information hoi,
2648: hr_lookups hl
2649: where hoi.organization_id = p_tax_unit_id
2650: and hoi.org_information_context = 'Federal Tax Rules'
2651: and hoi.org_information2 = hl.LOOKUP_CODE

Line 2657: from hr_organization_information hoi,

2653:
2654: Cursor c_get_sdi_self_adjust_method
2655: IS
2656: select hl.meaning
2657: from hr_organization_information hoi,
2658: hr_lookups hl
2659: where hoi.organization_id = p_tax_unit_id
2660: and hoi.org_information_context = 'State Tax Rules'
2661: and hoi.org_information1 = p_state_abbrev

Line 2668: from hr_organization_information hoi,

2664:
2665: Cursor c_get_sdi1_self_adjust_method
2666: IS
2667: select hl.meaning
2668: from hr_organization_information hoi,
2669: hr_lookups hl
2670: where hoi.organization_id = p_tax_unit_id
2671: and hoi.org_information_context = 'State Tax Rules2'
2672: and hoi.org_information1 = p_state_abbrev

Line 2679: from hr_organization_information hoi,

2675:
2676: Cursor c_get_sui_self_adjust_method
2677: IS
2678: select hl.meaning
2679: from hr_organization_information hoi,
2680: hr_lookups hl
2681: where hoi.organization_id = p_tax_unit_id
2682: and hoi.org_information_context = 'State Tax Rules'
2683: and hoi.org_information1 = p_state_abbrev