DBA Data[Home] [Help]

APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on DUAL

Line 386: from dual;

382: statement_no := 'A';
383:
384: select sysdate
385: into start_time
386: from dual;
387:
388: statement_no := 'B';
389:
390: select term_id

Line 584: from dual;

580:
581: statement_no := 'J';
582: select fv_dc_autoinv_header_s.nextval
583: into v_autoinv_seq_nbr
584: from dual;
585:
586: v_line_num := 1;
587: END IF;
588:

Line 878: from dual;

874:
875: select (decode(v_account_class,'REC',rec_ccid,'REV',rev_ccid))
876: into
877: fc_dm_dist_rec.code_combination_id
878: from dual;
879:
880:
881: fc_dm_dist_rec.org_id := v_org_id;
882: fc_dm_dist_rec.created_by := FND_GLOBAL.USER_ID;

Line 1113: from dual;

1109:
1110: BEGIN
1111: select ar_adjustments_s.nextval
1112: into v_adjustment_id
1113: from dual;
1114: EXCEPTION
1115: when others then
1116: error_message := 'B.1 '||sqlerrm;
1117: raise ORACLE_ERROR;

Line 1159: from dual;

1155: -- calls various internal packages and procedures for adjustment
1156:
1157: select ar_adjustment_number_s.nextval
1158: into v_adjustment_number
1159: from dual;
1160:
1161: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1163: 'Calling INSERT_ADJUST_COVER to adjust'||