DBA Data[Home] [Help]

APPS.OKC_TIME_UTIL_PVT dependencies on STANDARD

Line 79: /* The following SQL clause was changed by msengupt to handle displaying in a higher User's Unit instead of the Standard Seeded Base Units.

75: WHERE tce_code = p_timeunit
76: AND active_flag = 'Y'
77: AND quantity = 1
78: */
79: /* The following SQL clause was changed by msengupt to handle displaying in a higher User's Unit instead of the Standard Seeded Base Units.
80: e.g. If the user has defined Quarter as 3 Month (Seeded) and also Month as 1 Month (Seeded) in the Time Code Units,
81: the period and duration between 1/1/2000 and 6/30/2001 will be returned as 18 Months by the earlier approach. Now with the
82: query being modified to add an OR clause with Mod, The user's entry of Quarter will be considered and the query will return 6 Quarter - Bug#1821715
83: */