APPS.AZ_COMP_REPORTER dependencies on DUAL

Line 172: ---LMATHUR - need to update the individual counts based on the number of differences

168:
169: /*v_data_pid_B*/);
170: COMMIT;
171: update_for_show_only_diff(p_request_id, p_source);
172: ---LMATHUR - need to update the individual counts based on the number of differences
173: update_diff_type_counts(p_request_id, p_source);
174: COMMIT;
175:
176: EXCEPTION

Line 302: FROM dual;

298:
299: /* a is null/empty and b is not empty) or (b is null/empty and a is not empty) or (a is not equal to b) */
300: select decode(existsNode(v_temp_xmltype,'/H/V[((not(./A/text()!="") and ./B/text()!="") or (not(./B/text()!="") and ./A/text()!="") or (./A/text()!=./B/text())) and not(@U="Y")]'),1,'C','N')
301: INTO v_is_different
302: FROM dual;
303:
304: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
305: INTO v_exclude_details_temp
306: FROM dual;

Line 306: FROM dual;

302: FROM dual;
303:
304: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
305: INTO v_exclude_details_temp
306: FROM dual;
307:
308: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
309: v_exclude_details := 'Y';
310: ELSE

Line 455: FROM dual;

451: AND is_primary = 'Y';
452:
453: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
454: INTO v_exclude_details_temp
455: FROM dual;
456:
457: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
458: v_exclude_details := 'Y';
459: ELSE

Line 573: FROM dual;

569: AND is_primary = 'N';
570:
571: SELECT existsnode(v_temp_xmltype, '/H/V[not(@U="Y")]')
572: INTO v_exclude_details_temp
573: FROM dual;
574:
575: IF(v_exclude_details_temp = '0' OR exclude_details = 'Y') THEN
576: v_exclude_details := 'Y';
577: ELSE