APPS.INV_TXN_MANAGER_GRP dependencies on INV_LE_TIMEZONE_PUB

Line 9018: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)

9014: INTO acct_period_id
9015: FROM ORG_ACCT_PERIODS
9016: WHERE PERIOD_CLOSE_DATE IS NULL
9017: AND ORGANIZATION_ID = p_org_id
9018: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
9019: BETWEEN PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
9020: ORDER BY PERIOD_START_DATE DESC, SCHEDULE_CLOSE_DATE ASC;
9021:
9022: else

Line 9030: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)

9026: FROM ORG_ACCT_PERIODS
9027: WHERE PERIOD_CLOSE_DATE IS NULL
9028: AND ORGANIZATION_ID = p_org_id
9029: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
9030: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
9031: AND TRUNC(PERIOD_START_DATE) <=
9032: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id);
9033: end if;
9034:

Line 9032: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id);

9028: AND ORGANIZATION_ID = p_org_id
9029: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
9030: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
9031: AND TRUNC(PERIOD_START_DATE) <=
9032: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id);
9033: end if;
9034:
9035: return(acct_period_id);
9036: