APPS.INV_TXN_MANAGER_GRP dependencies on INV_LE_TIMEZONE_PUB

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

8445: INTO acct_period_id
8446: FROM ORG_ACCT_PERIODS
8447: WHERE PERIOD_CLOSE_DATE IS NULL
8448: AND ORGANIZATION_ID = p_org_id
8449: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
8450: BETWEEN PERIOD_START_DATE and SCHEDULE_CLOSE_DATE
8451: ORDER BY PERIOD_START_DATE DESC, SCHEDULE_CLOSE_DATE ASC;
8452:
8453: else

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

8457: FROM ORG_ACCT_PERIODS
8458: WHERE PERIOD_CLOSE_DATE IS NULL
8459: AND ORGANIZATION_ID = p_org_id
8460: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
8461: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
8462: AND TRUNC(PERIOD_START_DATE) <=
8463: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id);
8464: end if;
8465:

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

8459: AND ORGANIZATION_ID = p_org_id
8460: AND TRUNC(SCHEDULE_CLOSE_DATE) >=
8461: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id)
8462: AND TRUNC(PERIOD_START_DATE) <=
8463: INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(NVL(p_trans_date,SYSDATE),p_org_id);
8464: end if;
8465:
8466: return(acct_period_id);
8467: