DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on DUAL

Line 5541: FROM DUAL

5537: AND trunc(nvl(i3.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5538: AND trunc(nvl(i3.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5539: UNION ALL
5540: SELECT nvl(c_parent_instance_id, -1)
5541: FROM DUAL
5542: )
5543: AND i2.relationship_type_code = 'COMPONENT-OF'
5544: AND trunc(nvl(i2.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5545: AND trunc(nvl(i2.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5670: FROM DUAL

5666: AND trunc(nvl(i3.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5667: AND trunc(nvl(i3.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
5668: UNION ALL
5669: SELECT nvl(c_parent_instance_id, -1)
5670: FROM DUAL
5671: )
5672: AND EXISTS
5673: (SELECT 1
5674: FROM csi_ii_relationships CI

Line 5980: FROM dual;

5976: SELECT decode(l_top_uc_status, 'DRAFT', 'DRAFT',
5977: 'APPROVAL_REJECTED', 'DRAFT',
5978: 'COMPLETE','COMPLETE',
5979: 'INCOMPLETE','COMPLETE', NULL) INTO l_top_uc_status
5980: FROM dual;
5981:
5982: --Based on profile value open the cursor.
5983: -- SATHAPLI Bug# 4912576 fix
5984: -- Code pertaining to Org check has been removed from here