APPS.XLE_UTILITIES_GRP dependencies on DUAL

Line 378: from dual;

374: l_party_ID := p_party_ID;
375:
376: SELECT to_number(l_party_ID)
377: INTO party_ID
378: from dual;
379: END IF;
380:
381:
382: IF p_establishment_ID is null THEN

Line 388: from dual;

384: ELSE
385: l_establishment_ID := p_establishment_ID;
386: SELECT to_number(l_establishment_ID)
387: INTO establishment_ID
388: from dual;
389: END IF;
390:
391: IF p_legalentity_id IS NULL THEN
392: l_legalentity_id := '%';

Line 824: from dual;

820: l_entity_id := p_entity_id;
821:
822: select to_date(p_effective_date,'DD-MM-YYYY')
823: into l_effective_date
824: from dual;
825:
826: begin
827:
828: for history_dated_r in history_dated_c loop