APPS.JA_CN_SYSOPS_BANK_PKG dependencies on GL_LEDGERS

Line 55: gl_ledgers lg,

51: xep.name legal_entity_name,
52: lg.ledger_id,
53: rs.primary_ledger_id
54: from gl_ledger_config_details primdet,
55: gl_ledgers lg,
56: gl_ledger_relationships rs,
57: gl_ledger_configurations cfg,
58: gl_ledger_config_details cfgdet,
59: XLE_ENTITY_PROFILES xep

Line 130: FROM gl_ledgers gls

126: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
127: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
128: AND fifsv.ID_FLEX_NUM in
129: (SELECT chart_of_accounts_id
130: FROM gl_ledgers gls
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

Line 257: gl_ledgers lg,

253: --Legal entity under the ledger
254: CURSOR CUR_LE IS
255: select cfgdet.object_id legal_entity_id
256: from gl_ledger_config_details primdet,
257: gl_ledgers lg,
258: gl_ledger_relationships rs,
259: gl_ledger_configurations cfg,
260: gl_ledger_config_details cfgdet
261: where rs.application_id = 101

Line 300: FROM gl_ledgers gls

296: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
297: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
298: AND fifsv.ID_FLEX_NUM in
299: (SELECT chart_of_accounts_id
300: FROM gl_ledgers gls
301: where gls.ledger_id = p_ledger_id);
302:
303: --Whether assigned bsv to all legal entity
304: FOR l_le in CUR_LE

Line 389: FROM gl_ledgers gls

385: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
386: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
387: AND fifsv.ID_FLEX_NUM in
388: (SELECT chart_of_accounts_id
389: FROM gl_ledgers gls
390: where gls.ledger_id = p_ledger);
391:
392: --get bsv summary
393: SELECT SUMMARY_FLAG

Line 475: gl_ledgers lg,

471: IS
472: CURSOR CUR_LEGAL IS
473: select cfgdet.object_id legal_entity_id
474: from gl_ledger_config_details primdet,
475: gl_ledgers lg,
476: gl_ledger_relationships rs,
477: gl_ledger_configurations cfg,
478: gl_ledger_config_details cfgdet
479: where rs.application_id = 101

Line 517: FROM gl_ledgers gls

513: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
514: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
515: AND fifsv.ID_FLEX_NUM in
516: (SELECT chart_of_accounts_id
517: FROM gl_ledgers gls
518: where gls.ledger_id = p_ledger);
519: --Validate all legal entity under current ledger whether be assigned a bsv at least.
520: OPEN CUR_LEGAL;
521: LOOP

Line 643: FROM gl_ledgers gls

639: AND FSAV.APPLICATION_COLUMN_NAME = fifsv.APPLICATION_COLUMN_NAME
640: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
641: AND fifsv.ID_FLEX_NUM in
642: (SELECT chart_of_accounts_id
643: FROM gl_ledgers gls
644: where gls.ledger_id = p_ledger);
645: fnd_flex_server.check_value_security(p_security_check_mode => 'YH',
646: p_flex_value_set_id => l_flex_valueset_id,
647: p_parent_flex_value => null,