APPS.INV_TURNS dependencies on INV_LE_TIMEZONE_PUB

Line 1010: AND oap.schedule_close_date <= INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id)

1006: IN
1007: (SELECT oap.organization_id, oap.acct_period_id
1008: FROM org_acct_periods oap
1009: WHERE oap.open_flag = 'N'
1010: AND oap.schedule_close_date <= INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id)
1011: MINUS
1012: SELECT organization_id, acct_period_id
1013: FROM mtl_bis_inv_by_period)
1014: ORDER BY

Line 1029: AND oap.schedule_close_date <= INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id)

1025: FROM org_acct_periods oap,
1026: mtl_parameters mp
1027: WHERE oap.organization_id = mp.organization_id
1028: AND oap.open_flag = 'N'
1029: AND oap.schedule_close_date <= INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id)
1030: AND mp.process_enabled_flag <> 'Y' -- Added for R12 uptake. Ignore all data in process orgs.
1031: AND EXISTS -- Changed from NOT EXISTS to EXISTS for Bug 5099039
1032: (SELECT mbibp.acct_period_id, mbibp.organization_id
1033: FROM mtl_bis_inv_by_period mbibp

Line 1104: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id) >= period_start_date

1100: FROM ORG_ACCT_PERIODS oap, mtl_parameters mp
1101: WHERE oap.open_flag = 'Y'
1102: AND oap.organization_id = mp.organization_id
1103: AND mp.process_enabled_flag <> 'Y' -- Added for R12 uptake. Ignore all data in process orgs.
1104: AND INV_LE_TIMEZONE_PUB.get_le_day_for_inv_org(Sysdate,oap.organization_id) >= period_start_date
1105: ORDER BY oap.organization_id, oap.schedule_close_date desc;
1106: -- Commented on mar 10th 2000. We shoould process the current period
1107: -- too. (AND schedule_close_date <= sysdate )
1108: -- mar 20th 2000 AND ( trunc(sysdate) BETWEEN period_start_date