APPS.JA_CN_SYSOPS_BANK_PKG dependencies on JA_CN_BANK_LE_GT

Line 414: INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);

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
417: --parent
418: FOR l_parent in CUR_PARENT(l_flex_valueset_id,l_bsv_temp) LOOP

Line 436: INSERT INTO JA_CN_BANK_LE_GT(LEGAL_ENTITY_ID,Balance_Segment,flag) VALUES(p_legal_entity,l_bsv_temp,l_exists);

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;
439: END IF;
440: END LOOP;

Line 542: SELECT (SELECT count(1) FROM JA_CN_BANK_LE_GT )

538: RETURN TRUE;
539: END IF;
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