[Home] [Help]
94: ELSIF p_entity_code = 'S' THEN
95:
96: SELECT 'x'
97: INTO l_dummy
98: FROM OE_SHIP_TO_ORGS_V
99: WHERE ORGANIZATION_ID = p_entity_id
100: UNION
101: SELECT 'x'
102: FROM OE_INVOICE_TO_ORGS_V
163: ELSIF p_entity_code2 = 'S' THEN
164:
165: SELECT 'x'
166: INTO l_dummy
167: FROM OE_SHIP_TO_ORGS_V
168: WHERE ORGANIZATION_ID = p_entity_id2
169: UNION
170: SELECT 'x'
171: FROM OE_INVOICE_TO_ORGS_V