APPS.FV_FUNDS_AVAILABLE_PKG dependencies on DUAL

Line 375: FROM dual;

371:
372: v_statement := 'D';
373: SELECT instr(acct_ff_low,v_delimiter,1,1)
374: INTO v_substr_to
375: FROM dual;
376: -- find position of first delimiter
377:
378: v_statement := 'E';
379: SELECT substr(acct_ff_low,1,v_substr_to - 1)

Line 381: FROM dual;

377:
378: v_statement := 'E';
379: SELECT substr(acct_ff_low,1,v_substr_to - 1)
380: INTO v_segment_low_value
381: FROM dual;
382: -- get first segment value
383:
384: v_value_low(v_segment_low_name) := v_segment_low_value;
385: -- assign value to table

Line 396: FROM dual;

392:
393: v_statement := 'F';
394: SELECT instr(acct_ff_low,v_delimiter,1,v_delim_occur)
395: INTO v_substr_from
396: FROM dual;
397: -- find position of delimiter occurance
398:
399: v_diff := v_substr_from - v_substr_to;
400: --bug 7534611. changed the condition from = to < and find value for last segment

Line 416: FROM dual;

412:
413: v_statement := 'G';
414: SELECT substr(acct_ff_low,v_substr_to + 1,v_diff - 1)
415: INTO v_segment_low_value
416: FROM dual;
417: -- find value of segment
418:
419: v_value_low(v_segment_low_name) := v_segment_low_value;
420: END IF;

Line 470: FROM dual;

466:
467: v_statement := 'H';
468: SELECT instr(acct_ff_high,v_delimiter,1,1)
469: INTO v_substr_to
470: FROM dual;
471: -- find position of first delimiter
472:
473: v_statement := 'I';
474: SELECT substr(acct_ff_high,1,v_substr_to - 1)

Line 476: FROM dual;

472:
473: v_statement := 'I';
474: SELECT substr(acct_ff_high,1,v_substr_to - 1)
475: INTO v_segment_high_value
476: FROM dual;
477: -- get first segment value
478:
479: v_value_high(v_segment_high_name) := v_segment_high_value;
480: -- assign value to table

Line 491: FROM dual;

487:
488: v_statement := 'J';
489: SELECT instr(acct_ff_high,v_delimiter,1,v_delim_occur)
490: INTO v_substr_from
491: FROM dual;
492: -- find position of delimiter occurance
493:
494: v_diff := v_substr_from - v_substr_to;
495:

Line 510: FROM dual;

506:
507: v_statement := 'K';
508: SELECT substr(acct_ff_high,v_substr_to + 1,v_diff - 1)
509: INTO v_segment_high_value
510: FROM dual;
511: -- find value of segment
512:
513: v_value_high(v_segment_high_name) := v_segment_high_value;
514: END IF;