APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_ACCOUNT_BALANCES_POST_GT

Line 1060: INSERT INTO ja_cn_account_balances_post_gt(

1056:
1057: IF l_cost_center_second_tracking
1058: THEN
1059: --insert all possible retain account into temp table
1060: INSERT INTO ja_cn_account_balances_post_gt(
1061: ledger_id
1062: , LEGAL_ENTITY_ID
1063: , COMPANY_SEGMENT
1064: , PERIOD_NAME

Line 1143: INSERT INTO ja_cn_account_balances_post_gt(

1139: AND nvl(jcc1.project_number,'0') =nvl(jcc.project_number,'0') ) );
1140:
1141: ELSE --l_cost_center_second_tracking = false
1142:
1143: INSERT INTO ja_cn_account_balances_post_gt(
1144: ledger_id
1145: , LEGAL_ENTITY_ID
1146: , COMPANY_SEGMENT
1147: , PERIOD_NAME

Line 1227: UPDATE ja_cn_account_balances_post_gt u

1223:
1224: END IF;--l_cost_center_second_tracking
1225:
1226: --update the period net occurance DR and CR
1227: UPDATE ja_cn_account_balances_post_gt u
1228: SET (FUNC_PERIOD_NET_DR
1229: , FUNC_PERIOD_NET_CR
1230: , ORIG_PERIOD_NET_DR
1231: , ORIG_PERIOD_NET_CR

Line 1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;

1252: AND PERSONNEL_ID IS NULL
1253: AND PERSONNEL_NUMBER IS NULL
1254: );
1255:
1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1257:
1258: --update the first priod begin balance in each year
1259: UPDATE ja_cn_account_balances_post_gt u
1260: SET ( FUNC_BEGIN_BALANCE_DR

Line 1259: UPDATE ja_cn_account_balances_post_gt u

1255:
1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1257:
1258: --update the first priod begin balance in each year
1259: UPDATE ja_cn_account_balances_post_gt u
1260: SET ( FUNC_BEGIN_BALANCE_DR
1261: , FUNC_BEGIN_BALANCE_CR
1262: , ORIG_BEGIN_BALANCE_DR
1263: , ORIG_BEGIN_BALANCE_CR)=

Line 1290: UPDATE ja_cn_account_balances_post_gt u

1286: AND gb.actual_flag = 'A'
1287: )
1288: WHERE period_mon=1;
1289:
1290: UPDATE ja_cn_account_balances_post_gt u
1291: SET FUNC_BEGIN_BALANCE_DR = nvl(FUNC_BEGIN_BALANCE_DR,0)
1292: , FUNC_BEGIN_BALANCE_CR = nvl(FUNC_BEGIN_BALANCE_CR,0)
1293: , ORIG_BEGIN_BALANCE_DR = nvl(ORIG_BEGIN_BALANCE_DR,0)
1294: , ORIG_BEGIN_BALANCE_CR = nvl(ORIG_BEGIN_BALANCE_CR,0)

Line 1307: UPDATE ja_cn_account_balances_post_gt u

1303: FROM ja_cn_periods jcp;
1304:
1305: FOR i IN 2..l_number
1306: LOOP
1307: UPDATE ja_cn_account_balances_post_gt u
1308: SET (FUNC_BEGIN_BALANCE_DR
1309: , FUNC_BEGIN_BALANCE_CR
1310: , ORIG_BEGIN_BALANCE_DR
1311: , ORIG_BEGIN_BALANCE_CR )=

Line 1316: FROM ja_cn_account_balances_post_gt

1312: (SELECT FUNC_BEGIN_BALANCE_DR + FUNC_PERIOD_NET_DR
1313: , FUNC_BEGIN_BALANCE_CR + FUNC_PERIOD_NET_CR
1314: , ORIG_BEGIN_BALANCE_DR + ORIG_PERIOD_NET_DR
1315: , ORIG_BEGIN_BALANCE_CR + ORIG_PERIOD_NET_CR
1316: FROM ja_cn_account_balances_post_gt
1317: WHERE period_num=u.period_num - 1
1318: AND ledger_id = p_ledger_id
1319: AND LEGAL_ENTITY_ID = p_legal_entity_ID
1320: AND COMPANY_SEGMENT = u.company_segment

Line 1340: FROM ja_cn_account_balances_post_gt t

1336: -- replace the new balance of retain earning account
1337: DELETE ja_cn_account_balances u
1338: WHERE EXISTS
1339: (SELECT *
1340: FROM ja_cn_account_balances_post_gt t
1341: WHERE t.ledger_id =u.ledger_id
1342: AND t.LEGAL_ENTITY_ID =u.LEGAL_ENTITY_ID
1343: AND t.COMPANY_SEGMENT =u.COMPANY_SEGMENT
1344: AND t.CURRENCY_CODE =u.CURRENCY_CODE

Line 1417: FROM ja_cn_account_balances_post_gt;

1413: , SYSDATE
1414: , fnd_global.USER_ID
1415: , SYSDATE
1416: , fnd_global.LOGIN_ID
1417: FROM ja_cn_account_balances_post_gt;
1418:
1419: /* -- delete the old parent account balance
1420: DELETE ja_cn_account_balances jcb
1421: WHERE jcb.ledger_id = p_ledger_id

Line 1672: DELETE ja_cn_account_balances_post_gt;*/

1668: , jcc.parent_type;
1669:
1670:
1671: /* --initiate the working area
1672: DELETE ja_cn_account_balances_post_gt;*/
1673:
1674: --insert all parent account having only non-parent account
1675: /* INSERT INTO ja_cn_account_balances(
1676: ledger_id