DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FV_CFS_REP_TEMP_S

Line 395: SELECT fv_cfs_rep_temp_s.NEXTVAL

391: WHERE ledger_id = v_sob
392: AND application_id = parm_application_id
393: AND period_name = v_period_name;
394: /*Sequence for fv_cfs_rep_temp table */
395: SELECT fv_cfs_rep_temp_s.NEXTVAL
396: INTO v_sequence_id
397: FROM DUAL;
398:
399: get_qualifier_segments;

Line 2560: UPDATE fv_cfs_rep_temp SET col_4_amt = NVL(col_1_amt,0) + NVL(col_2_amt,0) - NVL(col_3_amt,0),

2556: END IF;
2557: END IF;
2558:
2559: IF v_report_type = 'SCNP' THEN
2560: UPDATE fv_cfs_rep_temp SET col_4_amt = NVL(col_1_amt,0) + NVL(col_2_amt,0) - NVL(col_3_amt,0),
2561: col_8_amt = NVL(col_5_amt,0) + NVL(col_6_amt,0) - NVL(col_7_amt,0)
2562: WHERE sequence_id = v_sequence_id AND line_id = v_line_id;
2563:
2564: fnd_file.put_line