APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on DUAL

Line 66: FROM DUAL

62: DECLARE
63: l_new VARCHAR2(3);
64: BEGIN
65: SELECT 'Yes' INTO l_new
66: FROM DUAL
67: WHERE p_r_date BETWEEN NVL(P_PERIOD_START_DATE,TO_DATE('01-01-1690','DD-MM-RRRR'))
68: AND NVL(P_PERIOD_END_DATE,TO_DATE('31-12-2690','DD-MM-RRRR'));
69: RETURN(l_new);
70: EXCEPTION

Line 95: FROM DUAL

91: l_new VARCHAR2(3);
92: BEGIN
93: SELECT 'Yes'
94: INTO l_new
95: FROM DUAL
96: WHERE p_a_date BETWEEN NVL(p_period_start_date,TO_DATE('01-01-1700','DD-MM-RRRR')) AND NVL(p_period_end_date,TO_DATE('31-12-4000','DD-MM-RRRR'));
97: RETURN(l_new);
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN

Line 313: FROM DUAL

309: BEGIN
310: l_rd := 0;
311: SELECT 1
312: INTO l_rd
313: FROM DUAL
314: WHERE p_rev_date BETWEEN NVL(p_period_start_date,TO_DATE('01-01-1890' ,'DD-MM-RRRR')) AND NVL(p_period_end_date,TO_DATE('30-12-2199','DD-MM-RRRR'));
315: RETURN (l_rd);
316: EXCEPTION
317: WHEN NO_DATA_FOUND THEN

Line 340: FROM DUAL

336: l_new VARCHAR2(3);
337: BEGIN
338: SELECT 'Yes'
339: INTO l_new
340: FROM DUAL
341: WHERE p_rev_date BETWEEN NVL(p_period_start_date,TO_DATE('01-01-1690','DD-MM-RRRR')) AND NVl(p_period_end_date,TO_DATE('31-12-2690','DD-MM-RRRR'));
342: RETURN(l_new);
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN