APPS.HZ_TAX_ASSIGNMENT_PUB dependencies on DUAL

Line 81: FROM dual;

77: SELECT
78: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
79: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
80: INTO l_org_id
81: FROM dual;
82:
83: /*
84: IF l_org_id is NULL or l_org_id = -99 THEN
85:

Line 203: FROM DUAL

199: --
200: BEGIN
201: SELECT 'Y'
202: INTO l_is_remit_to_location
203: FROM DUAL
204: WHERE EXISTS ( SELECT 1
205: FROM hz_party_sites ps
206: WHERE ps.location_id = p_location_id
207: AND ps.party_id = -1);