APPS.WIP_CHANGE_STATUS dependencies on INV_LE_TIMEZONE_PUB

Line 92: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_release_date,

88: WHERE WC.CLASS_CODE = P_class_code
89: AND WC.ORGANIZATION_ID = P_organization_id
90: AND OAP.ORGANIZATION_ID = P_organization_id
91: AND OAP.SCHEDULE_CLOSE_DATE >=
92: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_release_date,
93: P_organization_id))
94: AND OAP.PERIOD_CLOSE_DATE IS NULL
95: AND NOT EXISTS
96: (SELECT 'balance record already there'

Line 135: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,

131: AND OAP.ORGANIZATION_ID = P_organization_id
132: AND OAP.PERIOD_CLOSE_DATE IS NULL
133: AND OAP.SCHEDULE_CLOSE_DATE >=
134: (SELECT NVL(MIN(
135: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
136: P_organization_id))),
137: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
138: P_organization_id)))
139: FROM WIP_REPETITIVE_SCHEDULES

Line 137: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,

133: AND OAP.SCHEDULE_CLOSE_DATE >=
134: (SELECT NVL(MIN(
135: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(DATE_RELEASED,
136: P_organization_id))),
137: TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(P_RELEASE_DATE,
138: P_organization_id)))
139: FROM WIP_REPETITIVE_SCHEDULES
140: WHERE WIP_ENTITY_ID = P_wip_entity_id
141: AND ORGANIZATION_ID = P_organization_id

Line 170: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(

166: CURSOR C1 IS
167: SELECT 'x'
168: FROM ORG_ACCT_PERIODS
169: WHERE ORGANIZATION_ID = P_Organization_Id
170: AND TRUNC(INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(
171: P_RELEASE_DATE,P_Organization_Id))
172: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
173: AND PERIOD_CLOSE_DATE IS NULL;
174: dummy VARCHAR2(2);