DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on HR_ORGANIZATION_UNITS

Line 1169: FROM hr_organization_units hou,

1165: g_state ,
1166: g_county ,
1167: g_country ,
1168: g_postal_code
1169: FROM hr_organization_units hou,
1170: hr_locations hl
1171: WHERE hou.location_id = hl.location_id
1172: AND hou.organization_id = g_legal_company_id
1173: and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);