7: begin
8: declare
9: cursor org_cursor IS
10: select ood.organization_name
11: from org_organization_definitions ood
12: where ood.organization_id = p_ship_to;
13: l_org_displayed org_organization_definitions.organization_name%type ;
14:
15:
9: cursor org_cursor IS
10: select ood.organization_name
11: from org_organization_definitions ood
12: where ood.organization_id = p_ship_to;
13: l_org_displayed org_organization_definitions.organization_name%type ;
14:
15:
16: begin
17: OPEN org_cursor;