APPS.CST_MGD_MSTR_BOOK_RPT dependencies on DUAL

Line 558: FROM DUAL;

554: -- Commented by ppandit
555: /* BEGIN
556: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_from)))
557: INTO p_date_from_formatting
558: FROM DUAL;
559: END;
560:
561: BEGIN
562: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_to)))

Line 564: FROM DUAL;

560:
561: BEGIN
562: SELECT FND_DATE.date_to_chardate (TRUNC (FND_DATE.canonical_to_date (p_date_to)))
563: INTO p_date_to_formatting
564: FROM DUAL;
565: END; */
566:
567: BEGIN
568: SELECT fc.extended_precision, gsob.currency_code

Line 1067: FROM SYS.dual;

1063: lc_sysdate VARCHAR2 (80);
1064: BEGIN
1065: SELECT TO_CHAR(SYSDATE, FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))
1066: INTO lc_sysdate
1067: FROM SYS.dual;
1068:
1069: RETURN (lc_sysdate);
1070: EXCEPTION
1071: WHEN OTHERS THEN

Line 1756: FROM SYS.dual;

1752: -- END;
1753: -- RETURN (GC_BREAK);
1754: SELECT p_break_by
1755: INTO ln_break_by
1756: FROM SYS.dual;
1757: RETURN (ln_break_by);
1758: END;
1759:
1760: --========================================================================

Line 1773: FROM SYS.dual;

1769: lc_detail_param VARCHAR2(10);
1770: BEGIN
1771: SELECT p_detail
1772: INTO lc_detail_param
1773: FROM SYS.dual;
1774: RETURN (lc_detail_param);
1775: END;
1776:
1777: --========================================================================

Line 1790: FROM SYS.dual;

1786: lc_incl_cost VARCHAR2(10);
1787: BEGIN
1788: SELECT p_include_item_cost
1789: INTO lc_incl_cost
1790: FROM SYS.dual;
1791: RETURN (lc_incl_cost);
1792: END;
1793:
1794: -- +==========================================================================+

Line 1824: FROM SYS.dual;

1820: lc_date VARCHAR2 (50);
1821: BEGIN
1822: SELECT TO_CHAR (TO_DATE (p_date_from, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value('ICX_DATE_FORMAT_MASK'))
1823: INTO lc_date
1824: FROM SYS.dual;
1825:
1826: RETURN (lc_date);
1827: END get_date_from;
1828:

Line 1844: FROM SYS.dual;

1840: lc_date VARCHAR2 (50);
1841: BEGIN
1842: SELECT TO_CHAR (TO_DATE (p_date_to, 'YYYY/MM/DD HH24:MI:SS'), FND_PROFILE.value ('ICX_DATE_FORMAT_MASK'))
1843: INTO lc_date
1844: FROM SYS.dual;
1845:
1846: RETURN (lc_date);
1847: END get_date_to;
1848:

Line 2374: from dual;

2370: exception
2371: when no_data_found then
2372: select 'No TXN Source'
2373: INTO l_rpt_item_tbl_rec(l_index).txn_source
2374: from dual;
2375: end;
2376:
2377: Get_Txn_Type
2378: ( p_txn_type_id => l_item_txn_info.Transaction_Type_ID