DBA Data[Home] [Help]

APPS.CST_COSTPROCVALIDATION_PVT dependencies on INV_LE_TIMEZONE_PUB

Line 231: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))

227: AND oap.organization_id = mmt.organization_id
228: AND hoi.organization_id = oap.organization_id
229: AND oap.acct_period_id = mmt.acct_period_id
230: AND (mmt.transaction_date -
231: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))
232: >= oap.period_start_date
233: AND (mmt.transaction_date -
234: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))
235: < oap.schedule_close_date+1));

Line 234: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))

230: AND (mmt.transaction_date -
231: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))
232: >= oap.period_start_date
233: AND (mmt.transaction_date -
234: (INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, TO_NUMBER(hoi.org_information2)) - SYSDATE ))
235: < oap.schedule_close_date+1));
236:
237: l_stmt_num := 80;
238: /* VALIDATION 2,6,8,9,11,12: Cost group validation (non null, must be in ccga or default). */