APPS.PQP_HROSS_REPORTS dependencies on DUAL

Line 29: SELECT REPLACE(p_parameter1, ' ') INTO l_parameter1 FROM DUAL;

25:
26: IF p_parameter1 IS NOT NULL OR p_parameter2 IS NOT NULL THEN
27:
28: --remove blank spaces from in between
29: SELECT REPLACE(p_parameter1, ' ') INTO l_parameter1 FROM DUAL;
30: SELECT REPLACE(p_parameter2, ' ') INTO l_parameter2 FROM DUAL;
31:
32: IF l_parameter1 = l_parameter2 THEN
33: l_return_status := '=';

Line 30: SELECT REPLACE(p_parameter2, ' ') INTO l_parameter2 FROM DUAL;

26: IF p_parameter1 IS NOT NULL OR p_parameter2 IS NOT NULL THEN
27:
28: --remove blank spaces from in between
29: SELECT REPLACE(p_parameter1, ' ') INTO l_parameter1 FROM DUAL;
30: SELECT REPLACE(p_parameter2, ' ') INTO l_parameter2 FROM DUAL;
31:
32: IF l_parameter1 = l_parameter2 THEN
33: l_return_status := '=';
34: ELSE

Line 339: SELECT to_char(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_date)), l_date_format) into l_return_value FROM dual;

335: l_return_value VARCHAR2(20);
336: l_date_format VARCHAR2(20);
337: BEGIN
338: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_format);
339: SELECT to_char(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_date)), l_date_format) into l_return_value FROM dual;
340: RETURN l_return_value;
341: END Get_Date;
342:
343: -- =============================================================================