eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_GEN_004 dependencies on DUAL

Line 435: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;

431: DurationDays := nvl(DurationDays,0);
432:
433: --4
434: IF ROUND_METHOD = 'A' THEN
435: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
436: ELSIF ROUND_METHOD = 'S' THEN
437: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
438: END IF;
439: -- if offsetdays is null

Line 437: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;

433: --4
434: IF ROUND_METHOD = 'A' THEN
435: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
436: ELSIF ROUND_METHOD = 'S' THEN
437: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
438: END IF;
439: -- if offsetdays is null
440: offsetdays := nvl(offsetdays,0);
441:

Line 618: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;

614:
615:
616: --applying round method
617: IF ROUND_METHOD = 'A' THEN
618: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
619: ELSIF ROUND_METHOD = 'S' THEN
620: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
621: END IF;
622: -- if offsetdays is null

Line 620: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;

616: --applying round method
617: IF ROUND_METHOD = 'A' THEN
618: SELECT ceil((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
619: ELSIF ROUND_METHOD = 'S' THEN
620: SELECT round((DurationDays*OffsetDuration)/100) INTO offsetdays FROM dual;
621: END IF;
622: -- if offsetdays is null
623: offsetdays := nvl(offsetdays,0);
624:

Line 913: SELECT ceil((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;

909:
910:
911: --4.
912: IF ROUND_METHOD = 'A' THEN
913: SELECT ceil((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
914: ELSIF ROUND_METHOD = 'S' THEN
915: SELECT round((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
916: END IF;
917: -- offsetdays is null

Line 915: SELECT round((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;

911: --4.
912: IF ROUND_METHOD = 'A' THEN
913: SELECT ceil((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
914: ELSIF ROUND_METHOD = 'S' THEN
915: SELECT round((meetingdays*offsetduration)/100) INTO offsetdays FROM dual;
916: END IF;
917: -- offsetdays is null
918: offsetdays := nvl(offsetdays,0);
919: