eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_JOBCLOSE_PRIV dependencies on INV_LE_TIMEZONE_PUB

Line 1418: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)

1414: INTO l_acct_period_id ,
1415: l_per_str_date,
1416: l_per_cls_date
1417: FROM ORG_ACCT_PERIODS
1418: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1419: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1420: AND ORGANIZATION_ID = p_organization_id;
1421:
1422: SELECT COUNT(*)

Line 1419: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)

1415: l_per_str_date,
1416: l_per_cls_date
1417: FROM ORG_ACCT_PERIODS
1418: WHERE INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) >= TRUNC(PERIOD_START_DATE)
1419: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (SYSDATE, p_organization_id) <= TRUNC(SCHEDULE_CLOSE_DATE)
1420: AND ORGANIZATION_ID = p_organization_id;
1421:
1422: SELECT COUNT(*)
1423: INTO l_std_org_count

Line 1736: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)

1732: SELECT ACCT_PERIOD_ID
1733: INTO l_acct_period_id
1734: FROM ORG_ACCT_PERIODS
1735: WHERE ORGANIZATION_ID = p_organization_id
1736: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (l_act_close_date,p_organization_id)
1737: BETWEEN PERIOD_START_DATE AND SCHEDULE_CLOSE_DATE
1738: AND PERIOD_CLOSE_DATE IS NULL;
1739:
1740: EXCEPTION

Line 2148: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (wdct.ACTUAL_CLOSE_DATE, wdct.ORGANIZATION_ID)

2144: AND we.organization_id = p_organization_id
2145: AND wdct.ORGANIZATION_ID = p_organization_id
2146: AND oap.ORGANIZATION_ID = p_organization_id
2147: AND oap.PERIOD_CLOSE_DATE IS NULL
2148: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (wdct.ACTUAL_CLOSE_DATE, wdct.ORGANIZATION_ID)
2149: BETWEEN oap.PERIOD_START_DATE and oap.SCHEDULE_CLOSE_DATE;
2150:
2151: /*==============================================================+
2152: | CALL COSTING function to update variances |