APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_ACCOUNT_CHILDREN_GT

Line 1532: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(

1528: AND ffv.summary_flag = 'Y'
1529: );
1530:
1531: -- generate the account structure to lowest level
1532: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
1533: parent_account
1534: , child_account
1535: , summary_flag
1536: , PARENT_TYPE

Line 1561: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(

1557: THEN
1558: EXIT;
1559: END IF;
1560:
1561: INSERT INTO JA_CN_ACCOUNT_CHILDREN_GT(
1562: parent_account
1563: , child_account
1564: , summary_flag
1565: , PARENT_TYPE

Line 1571: FROM JA_CN_ACCOUNT_CHILDREN_GT jca

1567: SELECT DISTINCT jca.parent_account
1568: , v.FLEX_VALUE
1569: , v.SUMMARY_FLAG
1570: , jca.parent_type
1571: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
1572: , FND_FLEX_VALUES v
1573: , FND_FLEX_VALUE_NORM_HIERARCHY h
1574: WHERE jca.child_account = h.parent_flex_value
1575: AND v.flex_value_set_id = l_flex_value_set_id

Line 1581: FROM JA_CN_ACCOUNT_CHILDREN_GT t

1577: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH
1578: AND ((V.SUMMARY_FLAG = 'Y' AND H.RANGE_ATTRIBUTE = 'P') OR
1579: (V.SUMMARY_FLAG = 'N' AND H.RANGE_ATTRIBUTE = 'C'))
1580: AND NOT EXISTS(SELECT *
1581: FROM JA_CN_ACCOUNT_CHILDREN_GT t
1582: WHERE t.parent_account = jca.parent_account
1583: AND t.child_account = v.FLEX_VALUE);
1584:
1585: IF SQL%ROWCOUNT = 0 THEN

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

1587: END IF;
1588:
1589: END LOOP;
1590:
1591: DELETE JA_CN_ACCOUNT_CHILDREN_GT WHERE summary_flag = 'Y';
1592:
1593: --insert the parent account balance
1594: INSERT INTO ja_cn_account_balances(
1595: ledger_id

Line 1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc

1652: , fnd_global.USER_ID
1653: , SYSDATE
1654: , fnd_global.LOGIN_ID
1655: FROM ja_cn_account_balances jcb
1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc
1657: , ja_cn_periods jcp
1658: WHERE jcc.child_account = jcb.account_segment
1659: AND jcp.ledger_id = p_ledger_id
1660: AND jcb.legal_entity_id = p_legal_entity_ID