APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_ACCOUNT_CHILDREN_GT

Line 2411: --Delete data from JA_CN_ACCOUNT_CHILDREN_GT for fixing bug 9582957

2407: AND ffv.flex_value = jcb.account_segment
2408: AND ffv.summary_flag = 'Y'
2409: );
2410:
2411: --Delete data from JA_CN_ACCOUNT_CHILDREN_GT for fixing bug 9582957
2412: DELETE FROM JA_CN_ACCOUNT_CHILDREN_GT;
2413: -- generate the account structure to lowest level
2414: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
2415: parent_account

Line 2412: DELETE FROM JA_CN_ACCOUNT_CHILDREN_GT;

2408: AND ffv.summary_flag = 'Y'
2409: );
2410:
2411: --Delete data from JA_CN_ACCOUNT_CHILDREN_GT for fixing bug 9582957
2412: DELETE FROM JA_CN_ACCOUNT_CHILDREN_GT;
2413: -- generate the account structure to lowest level
2414: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
2415: parent_account
2416: , child_account

Line 2414: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(

2410:
2411: --Delete data from JA_CN_ACCOUNT_CHILDREN_GT for fixing bug 9582957
2412: DELETE FROM JA_CN_ACCOUNT_CHILDREN_GT;
2413: -- generate the account structure to lowest level
2414: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
2415: parent_account
2416: , child_account
2417: , summary_flag
2418: , PARENT_TYPE

Line 2443: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(

2439: THEN
2440: EXIT;
2441: END IF;
2442:
2443: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
2444: parent_account
2445: , child_account
2446: , summary_flag
2447: , PARENT_TYPE

Line 2453: FROM JA_CN_ACCOUNT_CHILDREN_GT jca

2449: SELECT DISTINCT jca.parent_account
2450: , v.FLEX_VALUE
2451: , v.SUMMARY_FLAG
2452: , jca.parent_type
2453: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
2454: , FND_FLEX_VALUES v
2455: , FND_FLEX_VALUE_NORM_HIERARCHY h
2456: WHERE jca.child_account = h.parent_flex_value
2457: AND v.flex_value_set_id = l_flex_value_set_id

Line 2463: FROM JA_CN_ACCOUNT_CHILDREN_GT t

2459: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH
2460: AND ((V.SUMMARY_FLAG = 'Y' AND H.RANGE_ATTRIBUTE = 'P') OR
2461: (V.SUMMARY_FLAG = 'N' AND H.RANGE_ATTRIBUTE = 'C'))
2462: AND NOT EXISTS(SELECT *
2463: FROM JA_CN_ACCOUNT_CHILDREN_GT t
2464: WHERE t.parent_account = jca.parent_account
2465: AND t.child_account = v.FLEX_VALUE);
2466:
2467: IF SQL%ROWCOUNT = 0 THEN

Line 2473: DELETE JA_CN_ACCOUNT_CHILDREN_GT WHERE summary_flag = 'Y';

2469: END IF;
2470:
2471: END LOOP;
2472:
2473: DELETE JA_CN_ACCOUNT_CHILDREN_GT WHERE summary_flag = 'Y';
2474:
2475: --insert the parent account balance
2476: INSERT INTO ja_cn_account_balances(
2477: ledger_id

Line 2601: , JA_CN_ACCOUNT_CHILDREN_GT jcc

2597: , NULL
2598: , NULL
2599: , NULL
2600: FROM ja_cn_account_balances jcb
2601: , JA_CN_ACCOUNT_CHILDREN_GT jcc
2602: , ja_cn_periods jcp
2603: WHERE jcc.child_account = jcb.account_segment
2604: AND jcp.ledger_id = p_ledger_id
2605: AND jcb.legal_entity_id = p_legal_entity_ID