APPS.FV_FUNDS_AVAILABLE_PKG dependencies on DUAL

Line 359: FROM dual;

355:
356: v_statement := 'D';
357: SELECT instr(acct_ff_low,v_delimiter,1,1)
358: INTO v_substr_to
359: FROM dual;
360: -- find position of first delimiter
361:
362: v_statement := 'E';
363: SELECT substr(acct_ff_low,1,v_substr_to - 1)

Line 365: FROM dual;

361:
362: v_statement := 'E';
363: SELECT substr(acct_ff_low,1,v_substr_to - 1)
364: INTO v_segment_low_value
365: FROM dual;
366: -- get first segment value
367:
368: v_value_low(v_segment_low_name) := v_segment_low_value;
369: -- assign value to table

Line 380: FROM dual;

376:
377: v_statement := 'F';
378: SELECT instr(acct_ff_low,v_delimiter,1,v_delim_occur)
379: INTO v_substr_from
380: FROM dual;
381: -- find position of delimiter occurance
382:
383: v_diff := v_substr_from - v_substr_to;
384: --bug 7534611. changed the condition from = to < and find value for last segment

Line 400: FROM dual;

396:
397: v_statement := 'G';
398: SELECT substr(acct_ff_low,v_substr_to + 1,v_diff - 1)
399: INTO v_segment_low_value
400: FROM dual;
401: -- find value of segment
402:
403: v_value_low(v_segment_low_name) := v_segment_low_value;
404: END IF;

Line 454: FROM dual;

450:
451: v_statement := 'H';
452: SELECT instr(acct_ff_high,v_delimiter,1,1)
453: INTO v_substr_to
454: FROM dual;
455: -- find position of first delimiter
456:
457: v_statement := 'I';
458: SELECT substr(acct_ff_high,1,v_substr_to - 1)

Line 460: FROM dual;

456:
457: v_statement := 'I';
458: SELECT substr(acct_ff_high,1,v_substr_to - 1)
459: INTO v_segment_high_value
460: FROM dual;
461: -- get first segment value
462:
463: v_value_high(v_segment_high_name) := v_segment_high_value;
464: -- assign value to table

Line 475: FROM dual;

471:
472: v_statement := 'J';
473: SELECT instr(acct_ff_high,v_delimiter,1,v_delim_occur)
474: INTO v_substr_from
475: FROM dual;
476: -- find position of delimiter occurance
477:
478: v_diff := v_substr_from - v_substr_to;
479:

Line 494: FROM dual;

490:
491: v_statement := 'K';
492: SELECT substr(acct_ff_high,v_substr_to + 1,v_diff - 1)
493: INTO v_segment_high_value
494: FROM dual;
495: -- find value of segment
496:
497: v_value_high(v_segment_high_name) := v_segment_high_value;
498: END IF;