APPS.WIP_CHANGE_STATUS dependencies on INV_LE_TIMEZONE_PUB

Line 118: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_release_date,

114: WHERE WC.CLASS_CODE = P_class_code
115: AND WC.ORGANIZATION_ID = P_organization_id
116: AND OAP.ORGANIZATION_ID = P_organization_id
117: AND OAP.SCHEDULE_CLOSE_DATE >=
118: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_release_date,
119: P_organization_id))
120: AND OAP.PERIOD_CLOSE_DATE IS NULL
121: AND NOT EXISTS
122: (SELECT 'balance record already there'

Line 167: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,

163: AND OAP.ORGANIZATION_ID = P_organization_id
164: AND OAP.PERIOD_CLOSE_DATE IS NULL
165: AND OAP.SCHEDULE_CLOSE_DATE >=
166: (SELECT NVL(MIN(
167: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
168: P_organization_id))),
169: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
170: P_organization_id)))
171: FROM WIP_REPETITIVE_SCHEDULES

Line 169: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,

165: AND OAP.SCHEDULE_CLOSE_DATE >=
166: (SELECT NVL(MIN(
167: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
168: P_organization_id))),
169: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
170: P_organization_id)))
171: FROM WIP_REPETITIVE_SCHEDULES
172: WHERE WIP_ENTITY_ID = P_wip_entity_id
173: AND ORGANIZATION_ID = P_organization_id

Line 211: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(

207: CURSOR C1 IS
208: SELECT 'x'
209: FROM ORG_ACCT_PERIODS
210: WHERE ORGANIZATION_ID = P_Organization_Id
211: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(
212: P_RELEASE_DATE,P_Organization_Id))
213: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
214: AND PERIOD_CLOSE_DATE IS NULL;
215: dummy VARCHAR2(2);