APPS.JA_CN_SYSOPS_BANK_PKG dependencies on DUAL

Line 412: FROM DUAL;

408: AND trunc(nvl(end_date, sysdate), 'DD') >=
409: trunc(sysdate, 'DD')
410: AND FLEX_SEGMENT_VALUE = l_bsv_temp)
411: INTO l_exists
412: FROM DUAL;
413: IF l_exists =1 THEN
414: INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);
415: END IF;
416: ELSE

Line 434: FROM DUAL;

430: AND trunc(nvl(end_date, sysdate), 'DD') >=
431: trunc(sysdate, 'DD')
432: AND FLEX_SEGMENT_VALUE = l_bsv_temp)
433: INTO l_exists
434: FROM DUAL;
435: IF l_exists =1 THEN
436: INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);
437: EXIT;
438: END IF;

Line 533: FROM DUAL;

529: AND trunc(nvl(end_date, sysdate), 'DD') >=
530: trunc(sysdate, 'DD')
531: AND FLEX_VALUE_SET_ID = l_flex_valueset_id)
532: INTO l_exists
533: FROM DUAL;
534: l_accumulate :=l_accumulate+ l_exists;
535: END LOOP;
536: CLOSE CUR_LEGAL;
537: IF l_accumulate = 0 THEN

Line 544: FROM DUAL;

540:
541: Check_LE( p_ledger, p_legal_entity, p_bsv ) ;
542: SELECT (SELECT count(1) FROM JA_CN_BANK_LE_GT )
543: INTO l_exists
544: FROM DUAL;
545: IF l_exists =0 THEN
546: --the bsv don't belong to the le
547: RETURN FALSE;
548: ELSE