APPS.JA_CN_SYSOPS_BANK_PKG dependencies on GL_LEGAL_ENTITIES_BSVS

Line 81: FROM GL_LEGAL_ENTITIES_BSVS gleb

77: and ledger_id =c_ledger_id;
78:
79: CURSOR CUR_BSV(c_legal_id pls_integer) IS
80: SELECT gleb.flex_segment_value
81: FROM GL_LEGAL_ENTITIES_BSVS gleb
82: WHERE gleb.legal_entity_id = c_legal_id;
83:
84: CURSOR CUR_NON_BSV(c_flex_value_set_id pls_integer) IS
85: SELECT ffv.FLEX_VALUE

Line 135: from GL_LEGAL_ENTITIES_BSVS gle

131: where gls.ledger_id = l_ledger.ledger_id);
132:
133: FOR l_legal in CUR_LE(l_ledger.ledger_id) LOOP
134: select count(1) into l_bsv_count
135: from GL_LEGAL_ENTITIES_BSVS gle
136: where gle.legal_entity_id = l_legal.legal_entity_id;
137:
138: IF l_bsv_count>0 THEN
139: OPEN CUR_BSV(l_legal.legal_entity_id);

Line 227: GL_LEGAL_ENTITIES_BSVS gleb

223: CURSOR CUR_BSV IS
224: SELECT ffv.FLEX_VALUE, ffv.DESCRIPTION, ffv.FLEX_VALUE_SET_ID
225: FROM FND_FLEX_VALUE_SETS ffs,
226: FND_FLEX_VALUES_VL ffv,
227: GL_LEGAL_ENTITIES_BSVS gleb
228: WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
229: AND ffs.flex_value_set_id = gleb.flex_value_set_id
230: AND ffv.FLEX_VALUE = gleb.flex_segment_value
231: AND trunc(nvl(START_DATE_ACTIVE, sysdate), 'DD') <=

Line 307: from GL_LEGAL_ENTITIES_BSVS gle

303: --Whether assigned bsv to all legal entity
304: FOR l_le in CUR_LE
305: LOOP
306: select count(1) into l_bsv_count_t
307: from GL_LEGAL_ENTITIES_BSVS gle
308: where gle.legal_entity_id = l_le.legal_entity_id
309: and (sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate) );
310: l_bsv_count :=l_bsv_count + l_bsv_count_t;
311: END LOOP;

Line 403: FROM GL_LEGAL_ENTITIES_BSVS

399:
400: --child
401: IF l_summary='N' THEN
402: SELECT (SELECT COUNT(1)
403: FROM GL_LEGAL_ENTITIES_BSVS
404: WHERE LEGAL_ENTITY_ID = p_legal_entity
405: AND FLEX_VALUE_SET_ID = l_flex_valueset_id
406: AND trunc(nvl(start_date, sysdate), 'DD') <=
407: trunc(sysdate, 'DD')

Line 425: FROM GL_LEGAL_ENTITIES_BSVS

421: IF l_parent.SUMMARY_FLAG='Y' THEN
422: Check_LE(p_ledger,p_legal_entity,l_bsv_temp);
423: ELSE
424: SELECT (SELECT COUNT(1)
425: FROM GL_LEGAL_ENTITIES_BSVS
426: WHERE LEGAL_ENTITY_ID = p_legal_entity
427: AND FLEX_VALUE_SET_ID = l_flex_valueset_id
428: AND trunc(nvl(start_date, sysdate), 'DD') <=
429: trunc(sysdate, 'DD')

Line 525: FROM GL_LEGAL_ENTITIES_BSVS

521: LOOP
522: FETCH CUR_LEGAL INTO l_legal;
523: EXIT WHEN CUR_LEGAL%NOTFOUND;
524: SELECT (SELECT COUNT(1)
525: FROM GL_LEGAL_ENTITIES_BSVS
526: WHERE LEGAL_ENTITY_ID = l_legal.legal_entity_id
527: AND trunc(nvl(start_date, sysdate), 'DD') <=
528: trunc(sysdate, 'DD')
529: AND trunc(nvl(end_date, sysdate), 'DD') >=