DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on INV_LE_TIMEZONE_PUB

Line 746: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(

742: FROM ORG_ACCT_PERIODS OAP
743: WHERE OAP.ORGANIZATION_ID = WMTI.ORGANIZATION_ID
744: AND OAP.PERIOD_CLOSE_DATE IS NULL
745: AND OAP.OPEN_FLAG = 'Y'
746: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(
747: WMTI.TRANSACTION_DATE, -- p_trxn_date
748: WMTI.ORGANIZATION_ID -- p_inv_org_id
749: ))
750: BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE)

Line 798: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(

794: (SELECT oap.acct_period_id
795: FROM org_acct_periods oap
796: WHERE oap.organization_id = wmti.organization_id
797: -- modified the statement below for timezone project in J
798: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(
799: wmti.transaction_date, -- p_trxn_date
800: wmti.organization_id -- p_inv_org_id
801: )) BETWEEN
802: oap.period_start_date AND oap.schedule_close_date)

Line 3102: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(

3098: (SELECT oap.acct_period_id
3099: FROM org_acct_periods oap
3100: WHERE oap.organization_id = wmti.organization_id
3101: -- modified the statement below for timezone project in J
3102: AND TRUNC(inv_le_timezone_pub.get_le_day_for_inv_org(
3103: wmti.transaction_date, -- p_trxn_date
3104: wmti.organization_id -- p_inv_org_id
3105: )) BETWEEN
3106: oap.period_start_date AND oap.schedule_close_date)