24: (
25: X_ATTRIBUTE_NAME in VARCHAR2
26: ) is
27: select ATTRIBUTE_ID
28: from AME_ATTRIBUTES
29: where NAME = X_ATTRIBUTE_NAME
30: and sysdate between START_DATE
31: and nvl(END_DATE-(1/86400), sysdate);
32:
34: (
35: X_ATTRIBUTE_ID in VARCHAR2
36: ) is
37: select C.CREATED_BY
38: from AME_ATTRIBUTES C
39: where C.START_DATE =
40: (select min(A.START_DATE) from AME_ATTRIBUTES A
41: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
42: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
36: ) is
37: select C.CREATED_BY
38: from AME_ATTRIBUTES C
39: where C.START_DATE =
40: (select min(A.START_DATE) from AME_ATTRIBUTES A
41: where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
42: and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
43:
44: cursor CSR_GET_CURRENT_CONDITION
101: X_PARAMETER_TWO_NUMBER number;
102: begin
103: select ATTRIBUTE_TYPE
104: into X_ATTRIBUTE_TYPE
105: from AME_ATTRIBUTES
106: where NAME = X_ATTRIBUTE_NAME
107: and sysdate between START_DATE
108: and nvl(END_DATE-(1/86400), sysdate);
109: