APPS.JA_CN_UTILITY dependencies on JA_CN_SYSTEM_PARAMETERS_ALL

Line 226: FROM ja_cn_system_parameters_all

222:
223: BEGIN
224: /* SELECT l_ledger_id
225: INTO l_ledger_id
226: FROM ja_cn_system_parameters_all
227: WHERE legal_entity_id = p_legal_entity_id;
228: */ --log the SOB
229: IF (l_Statement_Level >= l_Runtime_Level)
230: THEN

Line 1264: ,ja_cn_system_parameters_all jcsp

1260: BEGIN
1261: l_Sql := 'SELECT nvl(jcask.concatenated_segments, '''')
1262: FROM ' || l_Acc_Stru_Tablename ||
1263: ' jcask
1264: ,ja_cn_system_parameters_all jcsp
1265: WHERE jcask.account_structure_id = jcsp.account_structure_id
1266: AND jcsp.legal_entity_id = :1';
1267: EXECUTE IMMEDIATE l_Sql
1268: INTO l_Result

Line 2318: FROM ja_cn_system_parameters_all jcspa

2314: jcspa.organization_id,
2315: jcspa.ent_quality,
2316: jcspa.ent_industry,
2317: jcspa.cnao_stand_ver
2318: FROM ja_cn_system_parameters_all jcspa
2319: WHERE jcspa.legal_entity_id = ln_legal_entity_id;
2320: BEGIN
2321:
2322: --log for debug

Line 2556: FROM ja_cn_system_parameters_all

2552:
2553: --get the system rounding rule
2554: SELECT rounding_rule
2555: INTO lv_rounding_rule
2556: FROM ja_cn_system_parameters_all
2557: WHERE legal_entity_id = pn_legal_entity_id;
2558:
2559: IF (lv_rounding_rule = 'N')
2560: THEN