DBA Data[Home] [Help]

APPS.PAY_NL_REM_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 843: ,hr_organization_units hou

839: ,hr_general.decode_lookup ('HR_NL_CITY'
840: ,hlc.town_or_city) city
841: ,hlc.country country
842: FROM hr_locations hlc
843: ,hr_organization_units hou
844: WHERE hou.business_group_id = p_business_group_id
845: AND hou.organization_id = l_tax_org_id
846: AND hlc.location_id = hou.location_id;
847: --=============================================================================

Line 983: FROM hr_organization_units hou

979: ***********************************************************/
980: CURSOR csr_tax_reg_no(c_employer_id IN NUMBER,
981: c_business_group_id IN NUMBER) IS
982: SELECT hoi.org_information4 tax_reg_number
983: FROM hr_organization_units hou
984: ,hr_organization_information hoi
985: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
986: AND hou.business_group_id = c_business_group_id
987: AND hou.organization_id = hoi.organization_id