DBA Data[Home] [Help]

APPS.INV_HV_TXN_PURGE dependencies on INV_LE_TIMEZONE_PUB

Line 81: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(x_period_start_date,x_organization_id)

77:
78: CURSOR get_open_period (x_period_start_date DATE , x_organization_id NUMBER )
79: IS SELECT 'OPEN' sdate
80: FROM org_acct_periods
81: WHERE INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(x_period_start_date,x_organization_id)
82: >= ( SELECT MIN(period_start_date)
83: FROM org_acct_periods
84: WHERE organization_id = x_organization_id
85: AND open_flag = 'Y'