DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on HR_ORGANIZATION_UNITS

Line 521: FROM hr_organization_units hou, mtl_parameters MP

517: IF (p_organization_id IS NOT NULL) THEN
518: -- AnRaj:Changes made for fixing bug#4919353, issue# 6
519: SELECT hou.organization_id
520: INTO x_organization_id
521: FROM hr_organization_units hou, mtl_parameters MP
522: WHERE hou.organization_id = mp.organization_id
523: AND hou.organization_id = p_organization_id
524: AND hou.organization_id IN
525: (SELECT organization_id

Line 534: FROM hr_organization_units hou, mtl_parameters MP

530: ELSE
531: -- AnRaj:Changes made for fixing bug#4919353, issue# 5
532: SELECT hou.organization_id
533: INTO x_organization_id
534: FROM hr_organization_units hou, mtl_parameters MP
535: WHERE hou.organization_id = mp.organization_id
536: AND hou.Name = p_org_name
537: AND hou.organization_id IN
538: (SELECT organization_id