DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on INV_LE_TIMEZONE_PUB

Line 727: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)

723: END IF;
724: SELECT acct_period_id
725: INTO l_acct_period_id
726: FROM org_acct_periods
727: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
728: >= trunc(period_start_date )
729: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
730: <= trunc(schedule_close_date)
731: AND organization_id = tab_input(1).organization_id;

Line 729: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)

725: INTO l_acct_period_id
726: FROM org_acct_periods
727: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
728: >= trunc(period_start_date )
729: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,tab_input(1).organization_id)
730: <= trunc(schedule_close_date)
731: AND organization_id = tab_input(1).organization_id;
732:
733: