APPS.OPI_DBI_RES_PKG dependencies on DUAL

Line 178: select sysdate into l_to_date from dual;

174: --}
175: END IF;
176:
177: -- check_missing_dates in time dimension
178: select sysdate into l_to_date from dual;
179: fii_time_api.check_missing_date (g_global_start_date,
180: l_to_date,
181: l_missing_day_flag,
182: l_min_miss_date, l_max_miss_date);

Line 1367: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances

1363: AND ravail.organization_id = mp.organization_id
1364: AND ravail.organization_id = rdtl.organization_id
1365: AND ravail.resource_id = rdtl.resource_id
1366: AND nvl(ravail.instance_id,0) = 0 -- resource level row
1367: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances
1368: AND ravail.shift_date BETWEEN p_start_date AND p_end_date
1369: AND ravail.shift_date >= trunc(rdtl.creation_date)
1370: AND pol.cost_type_id = cmm.cost_type_id
1371: GROUP BY

Line 1662: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances

1658: AND ravail.organization_id = mp.organization_id
1659: AND ravail.organization_id = rdtl.organization_id
1660: AND ravail.resource_id = rdtl.resource_id
1661: AND nvl(ravail.instance_id,0) = 0 -- resource level row
1662: AND NVL(ravail.resource_instance_id,0) = 0 -- exclude individual resource instances
1663: AND ravail.shift_date BETWEEN l_start_date AND l_end_date
1664: AND ravail.shift_date >= trunc(rdtl.creation_date)
1665: AND pol.cost_type_id = cmm.cost_type_id
1666: GROUP BY