APPS.INVTTMTX dependencies on ORG_ACCT_PERIODS

Line 31: FROM ORG_ACCT_PERIODS

27: G_TRANSACTION_DATE := trunc(nvl(transaction_date, sysdate));
28:
29: SELECT ACCT_PERIOD_ID, TRUNC(SCHEDULE_CLOSE_DATE)
30: INTO v_transaction_period_id,v_scheduled_close_date
31: FROM ORG_ACCT_PERIODS
32: WHERE PERIOD_CLOSE_DATE IS NULL
33: AND ORGANIZATION_ID = org_id
34: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
35: TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Nvl(transaction_date,Sysdate),org_id))

Line 80: FROM ORG_ACCT_PERIODS

76: G_CURRENT_DATE := trunc(sysdate);
77:
78: SELECT ACCT_PERIOD_ID
79: INTO v_current_period_id
80: FROM ORG_ACCT_PERIODS
81: WHERE PERIOD_CLOSE_DATE IS NULL
82: AND ORGANIZATION_ID = org_id
83: AND TRUNC(INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,org_id))
84: BETWEEN TRUNC(PERIOD_START_DATE) and