APPS.PAY_FR_DB_PAY_SETUP dependencies on PER_ORGANIZATION_UNITS

Line 837: from per_organization_units org

833: if p_organization_name is not NULL then
834: --
835: select org.organization_id
836: into v_organization_id
837: from per_organization_units org
838: where upper(org.name) = upper(p_organization_name)
839: and org.business_group_id + 0 = v_business_group_id;
840: --
841: else

Line 1301: from per_organization_units org

1297: if p_organization_name is not NULL then
1298: --
1299: select org.organization_id
1300: into v_organization_id
1301: from per_organization_units org
1302: where upper(org.name) = upper(p_organization_name)
1303: and org.business_group_id + 0 = v_business_group_id
1304: and v_effective_start_date between org.date_from
1305: and nvl(org.date_to,v_end_of_time);