DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on HR_OPERATING_UNITS

Line 894: FROM hr_operating_units hr,

890:
891: IF (p_group_id IS NULL) THEN
892: UPDATE ap_invoices_interface i
893: SET org_id = (SELECT hr.organization_id org_id
894: FROM hr_operating_units hr,
895: per_business_groups per
896: WHERE hr.business_group_id = per.business_group_id
897: AND mo_global.check_access(hr.organization_id) = 'Y'
898: AND hr.name = i.operating_unit)

Line 913: FROM hr_operating_units hr,

909: ELSE
910:
911: UPDATE ap_invoices_interface i
912: SET org_id = (SELECT hr.organization_id org_id
913: FROM hr_operating_units hr,
914: per_business_groups per
915: WHERE hr.business_group_id = per.business_group_id
916: AND mo_global.check_access(hr.organization_id) = 'Y'
917: AND hr.name = i.operating_unit)