DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on HR_ORGANIZATION_UNITS

Line 527: FROM hr_organization_units hou, mtl_parameters MP

523: IF (p_organization_id IS NOT NULL) THEN
524: -- AnRaj:Changes made for fixing bug#4919353, issue# 6
525: SELECT hou.organization_id
526: INTO x_organization_id
527: FROM hr_organization_units hou, mtl_parameters MP
528: WHERE hou.organization_id = mp.organization_id
529: AND hou.organization_id = p_organization_id
530: AND hou.organization_id IN
531: (SELECT organization_id

Line 540: FROM hr_organization_units hou, mtl_parameters MP

536: ELSE
537: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
538: SELECT hou.organization_id
539: INTO x_organization_id
540: FROM hr_organization_units hou, mtl_parameters MP
541: WHERE hou.organization_id = mp.organization_id
542: AND hou.Name = p_org_name
543: AND hou.organization_id IN
544: (SELECT organization_id