APPS.PAY_DB_PAY_SETUP dependencies on PER_ORGANIZATION_UNITS

Line 1326: from per_organization_units org

1322: if p_organization_name is not NULL then
1323: --
1324: select org.organization_id
1325: into v_organization_id
1326: from per_organization_units org
1327: where upper(org.name) = upper(p_organization_name)
1328: and org.business_group_id + 0 = v_business_group_id
1329: and v_effective_start_date between org.date_from
1330: and nvl(org.date_to,v_end_of_time);