APPS.JA_CN_CFSSE_CALCULATE_PKG dependencies on JA_CN_CFS_ROW_CGS_GT

Line 241: FROM ja_cn_cfs_row_cgs_gt

237:
238: -- this cursor is
239: CURSOR c_axis_seq IS
240: SELECT axis_seq
241: FROM ja_cn_cfs_row_cgs_gt
242: WHERE axis_set_id = l_axis_set_id
243: AND display_flag = 'Y'
244: ORDER BY axis_seq
245: FOR UPDATE;

Line 259: FROM ja_cn_cfs_row_cgs_gt

255: ,amount
256: ,last_year_amount
257: ,rowcnt
258: ,lincnt
259: FROM ja_cn_cfs_row_cgs_gt
260: WHERE axis_set_id = l_axis_set_id
261: AND display_flag = 'Y'
262: ORDER BY axis_seq;
263:

Line 270: ,ja_cn_cfs_row_cgs_gt jccrcg

266: SELECT jcccg.operator
267: ,jccrcg.lincnt
268: ,jccrcg.change_sign_flag
269: FROM ja_cn_cfs_calculations_gt jcccg
270: ,ja_cn_cfs_row_cgs_gt jccrcg
271: WHERE jcccg.axis_set_id = l_axis_set_id
272: AND jcccg.axis_seq = pc_axis_seg
273: AND jcccg.axis_set_id = jccrcg.axis_set_id
274: AND jcccg.cal_axis_seq = jccrcg.axis_seq

Line 441: UPDATE ja_cn_cfs_row_cgs_gt

437: 5,
438: '0');
439:
440: --Update current row with row count and line count
441: UPDATE ja_cn_cfs_row_cgs_gt
442: SET rowcnt = l_rowcnt,
443: lincnt = l_lincnt
444: WHERE CURRENT OF c_axis_seq;
445:

Line 452: --the table JA_CN_CFS_ROW_CGS_gt by cursor c_rows in ascending order of axis_seq

448: --FND_FILE.Put_Line(FND_FILE.LOG,
449: -- 'update row number');
450:
451: --Retrive all rows which display_flag is 'Y' and belong to rowset 'l_rowset_id' from
452: --the table JA_CN_CFS_ROW_CGS_gt by cursor c_rows in ascending order of axis_seq
453: FOR rec_rows IN c_rows
454: LOOP
455:
456: --log for debug