DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on DUAL

Line 5436: FROM DUAL

5432: AND trunc(nvl(i3.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5433: AND trunc(nvl(i3.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5434: UNION ALL
5435: SELECT nvl(c_parent_instance_id, -1)
5436: FROM DUAL
5437: )
5438: AND i2.relationship_type_code = 'COMPONENT-OF'
5439: AND trunc(nvl(i2.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5440: AND trunc(nvl(i2.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5563: FROM DUAL

5559: AND trunc(nvl(i3.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5560: AND trunc(nvl(i3.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5561: UNION ALL
5562: SELECT nvl(c_parent_instance_id, -1)
5563: FROM DUAL
5564: )
5565: AND EXISTS
5566: (SELECT 1
5567: FROM csi_ii_relationships CI

Line 5873: FROM dual;

5869: SELECT decode(l_top_uc_status, 'DRAFT', 'DRAFT',
5870: 'APPROVAL_REJECTED', 'DRAFT',
5871: 'COMPLETE','COMPLETE',
5872: 'INCOMPLETE','COMPLETE', NULL) INTO l_top_uc_status
5873: FROM dual;
5874:
5875: --Based on profile value open the cursor.
5876: -- SATHAPLI Bug# 4912576 fix
5877: -- Code pertaining to Org check has been removed from here